# Questions

# 1) # Using orderdetails table, show orderID, productID and NetSales. # NetSales is calculated as: NetSales = Unitprice * Quantity - Discount # for NetSales greater than 200.

# Hint : You cannot use alias in where clause, but you can use your definition of new # in the where clause

# 2) # Show customerID, CompanyName, ContactName, OrderID, OrderDate,Shipper Company name # for freights less than $50.

# HINT: Customers Orders Shippers inner joined.

# Q3) # For each customer, show customerID, CompanyName, ContactName, count of orders, sum of quantity

# HINT: customers, orders, orderdetails innerjoined, and group by

# Q4) # We are wondering the count of orders that have been placed by country but only focusing on countries that have more than 50 orders

# HINT : left join customers orders and group by country and having clause

# Q5) # Show all information about customers, their orders, order details, products purchased and suppliers used.

# HINT: All tables mentioned are inner joined #

Q6) # Show Product information where the current products cost less than $20 and sort by price in descending order.

# HINT: not discontinued