University of Minnesota – Twin Cities SQL Developer Queries Worksheet

Usetheattachedimage of the Northwind database to write the following queries:

1.List customers (list customer ID, company name, address, city, country with descriptive column name) who have NOT placed any orders.

Hint: consider a subquery

2.Find the product(s) (product id and product name) which has the most numbers of orders. (4 points)

Hint: you can count the number of orders for a product in the ORDERDETAILS table; consider JOIN, subquery, and HAVING.

3.Which product has the most total sales revenue ($)? Provide the product id, product name, and the total sales of the product ($) (in the account format) (4 points)

Hint: you can find the total sales ($) of a product in the ORDERDETAILS table; consider JOIN, subquery, and HAVING.

4.List all suppliers and their selling products (if any). Display suppler ID, supplier name, product ID and product name with descriptive column name in the ascending order of supplier name (4 points)

Hint: consider left or right join

Customers
CustomerCustomerDemo
Column Nam
Customer ID
Employee Territories
Column Name Condensed
Employee
TerritoryID
CustomerDemographics
Column Name Condens. Nul
CustomerTypeID nchar(10
Customer Des
Territories
Column Nar
Shippers
Column Name
nvercan
Region
countin Name
RegionID
nvarchar(40)
nvarchar(24)
Phone