Write these SQL queries with ACCESS.

1. Display all the columns in Customer for those that have one or more rows in Purchaser. (In other words, customers that have bought at least one vehicle.) Your overall strategy must be a subquery connected by an IN.

2. Display all the columns in Customer for those that have one or more rows in Purchaser. (In other words, customers that have bought at least one vehicle.) Your overall strategy must be a subquery connected by an EXISTS.

3. Display all the columns in Customer for those that have one or more rows in Purchaser. (In other words, customers that have bought at least one vehicle.) Your overall strategy must be a join. Your solution can not contain any subqueries. Note that the sequence of the output rows for Query 1, 2, and 3 may be different, but the overall data values returned must be identical.

4. Union together all 4 dealership code columns: dcode, edcode, vdcode, and rdcode.

5. Display all the columns in Invoice for those invoices that have an iprice that is at least $25,000 but not more than $40,000. Use BETWEEN in your solution.

6. Display vyear, row count, minimum weight, maximum weight, average weight, and total weight for each unique vyear value. Use just the Vehicle table.

7. Count the number of different (i.e., unique) values of ieid in Invoice.

8. Display vdcode for those dealerships that have less than 5 vehicles. Use just the Vehicle table.

9. For each employee, display its count of rows in Invoice followed by all its columns in Employee. Include zero counts. Do not use UNION in your solution.

10. Display the cid and clast columns in Customer for those customers that do not have a value for czip.