Southwind easy

From SQLZOO
Jump to navigation Jump to search

Southwind database: easy questions

List all the products ordered by customer c006. Include the description of the product, the date that the order was received and the number ordered.

For each product show the total number ordered. Include just the product code and the number ordered

Give the firm and the address of each company that placed an order on 12th February 2007.

Give all details of the order made by customer 'Assiduous Assoc.' on 12th February 2007. Include the product code, the description the price and the number ordered.

Find the total number of 'Wilmington' ordered by 'Contiguous Corp.'.

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects