Your assignment is to write and execute the SQL queries that will produce the data (record sets) requested below using the small ZAGI database in Microsoft Access. After you are able to run your SQL statement and get the desired result, copy your

1. SQL statement, and (2) the output (recordset) from each SQL statement

and include both below each question in this same Word document. You can use the Snipping Tool to copy the recordset. Submit your Word document through BBLearn.

1. Retrieve all fields from the product table.
2. Retrieve the productname, productprice, and vendorid from the product table for those products sold by vendor MK.
3. Retrieve the productname, productprice, and categoryID from the product table for those products which cost more than $100.
4. Retrieve the productname, productprice, and categoryID from the product table for those products which cost more than $100 AND have a categoryid CP. Use the structure below in your SQL statement:

SELECT fields

FROM table

WHERE criteria

AND criteria

5. Retrieve the productname, productprice, and categoryID from the product table for those products which cost more than $100 OR have the categoryid FW.

SELECT fields

FROM table

WHERE field criteria

OR field criteria

6. List the storeid and storezip for all stores in the C region.
7. List the productid, tid, and noofitems for all transactions where the noofitems is greater than 2. Hint: find the table that includes these three fields.