Write the queries inside ./queries.sql
under the corresponding comment:
- Display the ProductName and CategoryName for all products in the database. Returns 77 records.
- Display the order Id and shipper ShipperName for all orders placed before August 9 2012. Returns 429 records.
- Display the name and quantity of the products ordered in order with Id 10251. Sort by ProductName. Returns 3 records.
- Display the OrderID, customer's Company Name and the employee's Last Name for every order. All columns should be labeled clearly. Returns 16,789 records.
Write at least a paragraph
explaining how you will normalize the data on this table:
school_name | student1 | student2 | class1 | class2 |
---|---|---|---|---|
One Star Academy | John Doe | Jane Doe | Math | Science |
North Blue School | Mohamed Ali | Hamdi Jama | English | English |
Gabi School | Sarah Yusuf | Fowzi Ahmed | Biology | Math |
In SQL Try Editor at W3Schools.com:
- Find the number of shipments by each shipper.
- Find the top 5 best performing employees measured in number of orders.
- Find the top 5 best performing employees measured in revenue.
- Find the category that brings in the least revenue.
- Find the customer country with the most orders.
- Find the shipper that moves the most cheese measured in units.