Essential Question: How can I put data in order in a SQL Database?
Mastery Objectives:
SWBAT put data in alphabetical and numerical order in SQL.
Directions: Enter the following queries into the SQL Editor: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_orderby
then take a screen shot of your findings and put them into a google doc. Describe what is happening for each query.
SELECT * FROM Customers ORDER BY Country;
SELECT * FROM Customers ORDER BY Country DESC;
SELECT * FROM Customers ORDER BY Country, CustomerName;
SELECT * FROM Customers ORDER BY Country ASC, CustomerName DESC;
Create a query to order by postal codeĀ
Create a query to order by contact name in descending order
Create a query to order by customer name and country name
Create a query to order by contact name in ascending order and country in descending order
Create a query to order by city in descending order.