Question: Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question. The
Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question. The questions are: 1- Write an SQL query to show the CustomerName and Country of Customers. 2- Write an SQL query to show all Countries (no duplicates), order them alphabetically. 3- Write an SQL query to show the first name of all employees ordered by their last name in alphabetic order. 4- Write an SQL query to show the detail of all shippers. 5- Write an SQL query to show the top five expensive products. 6 - Write an SQL query to show all details of suppliers, only show five of them. 7- Write an SQL query to show all details of Categories. 8- Write an SQL query to show all details of Orders, show the recent ones on the top. 9- Write an SQL query to show product names, their units, and their prices. 10 - Write an SQL query to show all details of orders (from OrderDetails table).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
