Problem
1. Compose SQL queries (do not use QBE grid) for the following questions and execute the queries on TAL_Distributors" database (MS Access).
2. List the numbers and names of all customers.
3. List the complete item table.
4. List the number and name of all customers that are represented by rep 15.
5. List the number, first name and last name all sales Reps who earns more than $27000 commission.
6. List the number and name of all customers that are represented by rep 15 or that have a credit limit of $10,000.
7. Find the total of the balances for all customers.