Using ACCESS SQL and the corresponding file, generate the following queries (q1 , q2 , q3 , q4,

q5 and q6). Send the Access file that has the 6 queries.

1. q1 - CustomerNum, CustomerName and OrderNum of all customers, include customers who do not

they have orders.

2. q2 . . . The total in dollars of order number 21617 with the name Total Order.

3. q3 - The number of orders each client has. Include the CustomerNum and the number of

orders you've made.

4. q4 - Sheldon's customer name (CustomerName) with the name of their representatives

(LastName and FirstName). Use IMPLICIT JOIN.

5. q5 ' The name of Sheldon's customers (CustomerName) with the name of their representatives

(LastName and FirstName). Use JOIN EXPLCITO.

6. q6 ? The description and price of the items (parts) of order 21610. Use SUBQUERY.