USING THE ORACLE DEMO TABLES Write SQL scripts to retrieve the following using the Oracle demo tables:

1. The total number of customers in each sales area.

2. List the minimum salary for each job.

3. Show the total number of customers for each rep (repid).

4. List the average customer credit limit for each sales area.

5. Provide a figure for the total salaries of all employees.

6. List the total number of orders placed by each custid.

7. Show the total quantity of each product (prodid) ordered to date.

8. As per (1) above, but excluding customers in the SW area.

9. Show only cities with more than two customers.

10. The total number of customers for each repid but excluding any customers living in Leeds.

11. A script to prompt the user for a sales area and then to display the total number of customers in that area.

12. Show the total number of customers with names starting with B living in each city.

13. Show the total number of customers for each rep (repid), but only for reps with over 2 customers.

14. List the average salary for each job title, but include only job titles with more than two people, and exclude any jobs in Department 20.

15. For each rep, show the total number of customers with a credit limit of over 2000.