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.

FILE HOME CREATE EXTERNAL DATA DATABASE TOOLS DESIGN Sign in Hide Table XClear Layout Direct RelationshipsClose Edtonship ReportabAll Relationships Relationships Show Table All Relationships 1 Tools Relationships SECURITY WARNING Some active content has been disabled. Click for more details, Enable Content | >> | Relationships Invoice Purchaser inum ieid ivin icontract isold Cpinum 2 DO Employee Vehicle vvin dcode vyear vmake vbody vcolor vweight vfuel vcylinders 0O 1 edcode elast efirst emi ehire esalary estreet ecity estate ezip Customer Dealership cid dname dstreet dcity dstate dzip clast cfirst Cmi cstreet ccity cstate czip Relationship rdcode rcid Ready NUM LOCK