Southwind medium

From SQLZOO
Revision as of 14:43, 19 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Southwind database: medium questions

Give the name of the firm or firms who have placed no orders.

 

Create a list of products. For each product show the description and the total number ordered and the date of the most recent order.

 

Show the customer code, the received date and the total value of all purchase orders with a total value of at least £475.

 

List all shipments for the first week of February (2007-02-01 to 2007-02-07 inclusive). For each shipment show: the customer, the date of the shipment and the address. The address is the customer address as in tcust unless specified in tship

 

Show the total sales by month.

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense