摘要:
/*************** * Aggregation * ***************/ -- Find minimum msrp of all products select min(msrp) from product; -- Find maximum msrp of all products select max(msrp) from product; -- Top ... 阅读全文
摘要:
/*************** * join tables * ***************/ -- list all sales for FLEX and BLAZE; select * from product; select * from sales; -- what happens without a.product_id=b.product_id; -- use table... 阅读全文
摘要:
USE fitbit_new; insert into product (product_id, code, name, color, class, msrp) values (5, 'np1', 'new product 1', 'PINK','EVERYDAY', 49), (6, 'np2', 'new product 2', 'PINK','EVERYDAY', 29), (7, 'n... 阅读全文
摘要:
/*************************************** * DDL: Create Database * ***************************************/ -- drop existing database if exists; DROP DATABASE IF EXISTS fitbit_new;... 阅读全文