USING SQL DESIGN VIEW IN ACCESS

7. Read SQLourse2 -Step #5 HAVING then complete the following queries: From the items_ordered table, display item, the number of times the item was ordered and the maximum price for each item. Only display the results if the maximum price of the item is greater than 190. Save as Q5-2 (4 records). b. How many orders did each customer make and how much in total did they pay? Use the items_ordered table. Select the customerid, number of orders they made, and the sum of the price for customers who made more than 1 order. The display for the number of orders should be Nbrforders and the sum of price TotalPaid. Save as Q5-3 (8 records) 8. Read SQLCourse2 -Step #7 Combining Conditions then complete the following queries Select the item and price of all items that start with the letters 'S', 'P', or 'F'. Save as 07-2 (12 records) (Hint: it can help to get it to work in simple form, then add complexity... In this case, get the query to work with just S, and then modify for P or F.] quantity Click to Add 1 1 1 4 1 1 1 2 1 1 items_ordered customers Query1 orderid - customerid - order_date- item 10330 30-Jun-99 Pogo stick 2 10101 30-Jun-99 Raft 3 10298 01-Jul-99 Skateboard 4 10101 01-Jul-99 Life Vest 5 10299 06-Jul-99 Parachute 6 10339 27-Jul-99 Umbrella 7 10449 13-Aug-99 Unicycle 8 10439 14-Aug-99 Ski Poles 9 10101 18-Aug-99 Rain Coat 10 10449 01-Sep-99 Snow Shoes 11 10439 18-Sep-99 Tent 12 10298 19-Sep-99 Lantern 13 10410 28-Oct-99 Sleeping Bag 14 10438 01-Nov-99 Umbrella 15 10438 02-Nov-99 Pillow 16 10298 01-Dec-99 Helmet 17 10449 15-Dec-99 Bicycle 18 10449 22-Dec-99 Canoe 19 10101 30-Dec-99 Hoola Hoop 20 10330 01-Jan-00 Flashlight 21 10101 02-Jan-00 Lantern 22 10299 18-Jan-00 Inflatable Matt 23 10438 18-Jan-00 Tent Record: K 1 of 32 No Filter Search 1 2 price $28.00 $58.00 $33.00 $125.00 $1,250.00 $4.50 $180.79 $25.50 $18.30 $45.00 $88.00 $29.00 $89.22 $6.75 $8.50 $22.00 $380.50 $280.00 $14.75 $28.00 $16.00 $38.00 $79.99 1 1 1 1 1 1 3 4 1 1 1