[Solved] CSE3330 Homework #3

Given the schema of the w3schools.com online sample data, write the SQL to answer the following questions.

https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

If the answer to the question is a number, that number is provided in parenthesis after the question.

1. What are the names of all the Shippers?
2. What is the total Quantity for Orders with OrderID 10309? (75)

;

3. How many Suppliers are there? (29)
4. How many Suppliers have a mailing address in Germany? (3)

5. How many Suppliers are there in each country?

6. Show a Distinct list of all EmployeeIDs and ShipperIDs from Orders.

7. What is the first and last OrderDate? (1996-07-04 , 1997-02-12)

8. What are all the Orders that happened in 1997 and the ShipperID is 1?

9. What is the minimum price for each CategoryID?

10. What is the minimum price for each CategoryID assuming the SupplierID is less than 10?