Write Query or queries for Access 2016. For question 4

Products Product ID Product 1 Potato Chips-Sour Cream & Chives PO 2 Potato Chips - Regular 3 Potato Chips-Lite 4 Potato Chips- Ridged 5 Pretzels- small rings 6 Prezels-Large hard 7 Pretzels- sticks 8 Tortilla chips 9 Nacho Chips 10 Popcorn- Cheddar Cheese 11 Popcorn - Low Fat 12 Popcorn Butter Category ID S/carton Supplier ID 456 456 567 456 231 231 231 789 321 876 731 731 $7.99 $6.89 $10.29 $10.19 $6.79 $12.35 $4.55 $6.50 $7.70 $8.29 $12.10 $7.59 Order Details OrderlD Product ID(Quantity Payments CustiD Payment Date 2 $10.00 5/1/99 3 $10.00 5/6/99 4 $7.00 5/8/99 4$25.005/10/99 12 Orders OrderlD Customer ID Order Date Shipping Method 6 4/19/99 customer truck 41 4/19/99 customer truck 14/21/99 our truck 24/22/99 customer truck 4 4/23/88 lour truck Customers 1 Kroger K 2 Kroger Brodsky 199 New Hyde Park Dr ColumbusOH 3 Kroger Haprin Brice Mall Outlet Reynoldsburg JOH 4 Big Bear Myers 3 Livingston AVColumbus OH 5 Big Bear Zane 8700 Main Street Columbus OH 6 SuperDuper ane 110 Broad Street Columbus OH 43556- 43213- 3209- 3669- 43209- James Road columbus H Focus