Assignment 2

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) customers are coming from, and 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 offices.

5- Write an SQL query to show the top five expensive products.

6 – Write an SQL query to show all details of payments, show only five of them.

7- Write an SQL query to show all details of employees.

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, and their prices.

10 – Write an SQL query to show all details of orders (from OrderDetails table).