A Gentle Introduction to

SQL


Pick an engine:

Southwind database: medium questions

6 Identify the customers who placed no orders

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

8 List details of those orders for which the total value ordered does not match the total value shipped

9 List all shipments for February. For each shipment show: the customer, the date of the shipment, the address and the total value of the shipment. The address is the customer address as in tcust unless specified in tship

10 Identify the best selling product line for each month. The best selling product is the one with the greatest value of orders