Query 1 List all items purchased by each customer. Customer name, item name, price, and subtotal for each item should be shown. The results should be ordered by the customer's last name and then by subtotal, descendingly cus tomeri firstname lastname item quantity price subtotal 10298 Leroy 10298 Leroy 10298 Leroy 10298 Leroy 10298 Leroy 10330 Shawn 10330 Shawn 10330 Shawn 10413 Donald 10439 Conrad 10439 Conrad 10101 John 10101 John 2 $29. 00 $33. 00 1$22. 38 $22. 00 $12. 50 4$28. 00 $28. 00 $16. 75 4$32. 00 1$88. 00 2 $25. 50 4$125. 00 2 $88. 7 Brown Brown Brown Brown Brown Dalton Dalton Dalton Davids Giles Giles Gray ra Lantern Skateboard PocketKnift Helnet Ear Muffs Flashlight Pogo stick Shovel Lawnchair Tent Ski Poles Life Vest Sleeping Ba 22. 38 12. 5 112 16. 75 128 500 Query 2 Retrieve the total purchase made by each customer, ordered by the customer with the highest total purchase first customer1 firstname- lastname Brown Dalton Davids Giles Gray Howell subtotal 10298 Leroy 10330 Shawn 10413 Donald 10439 Conrad 10101 John 10410 Mary Ann 10315Lisa 10299 Elroy 10449 Isabela 10339 Anthony 147. 88 156. 75 128 139 813. 95 281. 72 ones Keller Moore Sanchez 1288 970. 79