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 yourSQL statement, and (2) the output (recordset) from each SQL statementand 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. Retrieve all fields from the product table. Retrieve the productname, productprice, and vendorid from the product table for those products sold by vendor MK. Retrieve the productname, productprice, and categoryID from the product table for those products which cost more than $100.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 fieldsFROM tableWHERE criteriaAND criteriaRetrieve the productname, productprice, and categoryID from the product table for those products which cost more than $100 OR have the categoryid FW. SELECT fieldsFROM tableWHERE field criteriaOR field criteriaList the storeid and storezip for all stores in the ‘C’ region. 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.