Using table definition below write SQL statement(s) to record in the database selling product number Dw11...

  

Transcribed Image Text:

Using table definition below write SQL statement(s) to record in the database selling product number Dw11 to customer number 148. (4) Table: customer CNUM Table: ORDERS ORDER NUM Table: orderline Table: part PART NUM AT94 21608 21610 21613 BV06 DL71 DR93 DW11 FD21 148 282 356 Ferguson's 842 All Season KV29 CNAME Al's Appliance and Sport Brookings Direct ORDER NUM PART NUM 21608 AT94 21610 DR93 ORDER_DATE 20/10/2007 20/10/2007 21/10/2007 DESCRIPTION Iron Home Gym Cordless Drill Gas Range Washer Stand Mixer Treadmill CNUM NUM ORDERED 11 1 148 356 408 CSTREET 2837 Greenway 3827 Devon 382 Wildwood 28 Lakeview QUOTED PRICE ON HAND 21.95 495 CLASS 50 HW 45 SG 21 HW 8 AP 12 AP 22 HW 9 SG CCITY Toronto ON Toronto ON Brampton ON Oakville ON CPROV PRICE 24.95 794.95 129.95 495 399.99 159.95 1390 CPCODE 33336 33321 33146 1111 Using table definition below write SQL statement(s) to record in the database selling product number Dw11 to customer number 148. (4) Table: customer CNUM Table: ORDERS ORDER NUM Table: orderline Table: part PART NUM AT94 21608 21610 21613 BV06 DL71 DR93 DW11 FD21 148 282 356 Ferguson's 842 All Season KV29 CNAME Al's Appliance and Sport Brookings Direct ORDER NUM PART NUM 21608 AT94 21610 DR93 ORDER_DATE 20/10/2007 20/10/2007 21/10/2007 DESCRIPTION Iron Home Gym Cordless Drill Gas Range Washer Stand Mixer Treadmill CNUM NUM ORDERED 11 1 148 356 408 CSTREET 2837 Greenway 3827 Devon 382 Wildwood 28 Lakeview QUOTED PRICE ON HAND 21.95 495 CLASS 50 HW 45 SG 21 HW 8 AP 12 AP 22 HW 9 SG CCITY Toronto ON Toronto ON Brampton ON Oakville ON CPROV PRICE 24.95 794.95 129.95 495 399.99 159.95 1390 CPCODE 33336 33321 33146 1111

Answer rating: 100% (QA)

Unfortunately there isnt enough context in your message to understand the question fully as it seems ... View the full answer