iv. vi. Deliverables: List the itemno, description, and qob for all inventory items where the quantity on hand is greater than 2:10. {name query InventoryGreaterThanZ] List all sales made by Dreaen in January in descending order by sales amount. (name query {DreaenianSalesJ Remember to restrict by 'Dreaen' rather than employee number (i.e., you will need to join two tables]. How many different types of inventory items does the firm currently stock? [name query Nmuberoi'lnventory'lypes) Calculate the commission earned by Martinez in January [name query MartinezlanCommission}. Remember to restrict by 'Martinea' rather than employee number (i.e., you will need to }oin two tables]. Note: You may need to use multiplication [employeecommission'amount as CommissionAmount) and SUM. Do not include Employeenn and EmployeeName. Calculate te total dollar value of all sales made in January sale. (name query TotalJanDollarSales] Calculate te average dollar value of all sales made by each salesperson in January. (name query AveragelanSalesPerSalesperson] Questions 1 and 2: Neatly hand-written REA diagrams. Submit a hard copy of this part at the beginning of class on Febniary 9. Question 3: Upload your Access database renamed with your last name and assignS to Blackboard. Also, copy and paste the SQL CODE AND query results into a word file name with your last name and assignS. For example, my database file would be Jimissignacodb and my word document would be JiaAassignSdoc. Send these two files electronically to Blackboard. Submissions with missing any of these nvo les will not be graded