Question: 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!