G Find the order number, description, number ordered and quoted price of all hardware (HW) part...

Transcribed Image Text:

G Find the order number, description, number ordered and quoted price of all hardware (HW) part sales*/ Select p. Description, ol. Order_Num, ol. Num_Ordered, ol. Quoted Price From TAL_Part p, TAL_Order_Line ol Where p. Class - 'HW'; H)/*What did Razorback Sport purchase? Please list the item descriptions, quoted price and number ordered"/ Select From Where I 1) List the order numbers and order dates for every part in the appliance class. You need to include part number and part description too */ Select o. Order Num, o. Order Date, ol. Part Num, p. Description From TAL_Part p. TAL_Orders o, TAL_Order_Line ol Where o. Order Num- ol. Order Num AND ol. Part Nump. Part Num AND p. Class'AP'; Customer Num 148 282 356 408 462 524 608 687 725 842 Customer Name Part Num AT94 BV06 CD52 DL71 DR93 DWII FD21 KL62 KT03 KV29 Razorback Sport Brookings Direct Ferguson's The Everything Shop Bargains Galore Kline's Johnson's Department Store Lee's Sport and Appliance Deerfield's Four Seasons All Season Street City 2837 Greenway Fillmore 3827 Devon Grove 382 Wildwood Northfield FL 1828 Raven Crystal FL 3829 Central Grove 838 Ridgeland Fillmore 372 Oxford Sheldon FL 282 Evergreen Altonville FL 32543 282 Columbia 28 Lakeview Description Iron Home Gym Induction Cooktop Cordless Drill Gas Range Washer Stand Mixer TAL_Customer Dryer Dishwasher Google Glass Sheldon Grove 21 8 12 22 12 State Zip 8 9 FL 33336 FL 33321 $431.50 33146 $5,785.00 33503 $5.285.25 33321 $3,412.00 FL 33336 $12,762.00 FL TAL_Part On Hand 50 45 32 FL 33321 Balance $6.550.00 Class HW SG AP HW AP AP HW AP AP SG 106. $5,000.00 33553 $248.00 $7,500.00 $8,221.00 $7,500.00 $2,851.00 Warehouse 3 2 1 3 2 3 Credit Limit $7,500.00 $10,000.00 $7,500.00 $5,000.00 $10,000.00 $15,000.00 $10,000.00 3 1 3 2 Rep Num 20 35 75 35 75 8 2 2 2 2 20 75 35 35 75 Price $24.95 $794.95 $265.00 $129.95 $495.00 $399.99 $159.95 $349.95 $595.00 $1,390.00 Rep Num 20 35 75 Last Name Sha Stark Sopranos First Name Wei Tony Tony Order Num 21608 21610 21613 21614 21617 21619 21623 Order Num 21608 21610 21610 21613 21614 21617 21617 21619 21623 TAL_Rep Street 624 Randall 532 Jackson 1626 Taylor TAL_Orders Order Date Customer Num 03/20/2014 148 03/20/2014 356 03/21/2014 408 03/21/2014 282 03/23/2014 608 03/23/2014 148 03/23/201 608 TAL_Order_Line Part Num AT94 DR93 DWII KL62 KT03 BV06 CD52 DR93 KV29 State Zip City Grove FL 33321 Sheldon FL 33553 Fillmore FL 33336 Num Ordered 11 1 1 4 2 2 4 1 2 Quoted Price $21.95 $495.00 $399.99 $329,95 $$95.00 $794.95 $190.00 $495.00 $1,290.00 Commission Rate $20.542.50 0.05 $39,216.00 0.07 $23.487.00 0.05 2 G Find the order number, description, number ordered and quoted price of all hardware (HW) part sales*/ Select p. Description, ol. Order_Num, ol. Num_Ordered, ol. Quoted Price From TAL_Part p, TAL_Order_Line ol Where p. Class - 'HW'; H)/*What did Razorback Sport purchase? Please list the item descriptions, quoted price and number ordered"/ Select From Where I 1) List the order numbers and order dates for every part in the appliance class. You need to include part number and part description too */ Select o. Order Num, o. Order Date, ol. Part Num, p. Description From TAL_Part p. TAL_Orders o, TAL_Order_Line ol Where o. Order Num- ol. Order Num AND ol. Part Nump. Part Num AND p. Class'AP'; Customer Num 148 282 356 408 462 524 608 687 725 842 Customer Name Part Num AT94 BV06 CD52 DL71 DR93 DWII FD21 KL62 KT03 KV29 Razorback Sport Brookings Direct Ferguson's The Everything Shop Bargains Galore Kline's Johnson's Department Store Lee's Sport and Appliance Deerfield's Four Seasons All Season Street City 2837 Greenway Fillmore 3827 Devon Grove 382 Wildwood Northfield FL 1828 Raven Crystal FL 3829 Central Grove 838 Ridgeland Fillmore 372 Oxford Sheldon FL 282 Evergreen Altonville FL 32543 282 Columbia 28 Lakeview Description Iron Home Gym Induction Cooktop Cordless Drill Gas Range Washer Stand Mixer TAL_Customer Dryer Dishwasher Google Glass Sheldon Grove 21 8 12 22 12 State Zip 8 9 FL 33336 FL 33321 $431.50 33146 $5,785.00 33503 $5.285.25 33321 $3,412.00 FL 33336 $12,762.00 FL TAL_Part On Hand 50 45 32 FL 33321 Balance $6.550.00 Class HW SG AP HW AP AP HW AP AP SG 106. $5,000.00 33553 $248.00 $7,500.00 $8,221.00 $7,500.00 $2,851.00 Warehouse 3 2 1 3 2 3 Credit Limit $7,500.00 $10,000.00 $7,500.00 $5,000.00 $10,000.00 $15,000.00 $10,000.00 3 1 3 2 Rep Num 20 35 75 35 75 8 2 2 2 2 20 75 35 35 75 Price $24.95 $794.95 $265.00 $129.95 $495.00 $399.99 $159.95 $349.95 $595.00 $1,390.00 Rep Num 20 35 75 Last Name Sha Stark Sopranos First Name Wei Tony Tony Order Num 21608 21610 21613 21614 21617 21619 21623 Order Num 21608 21610 21610 21613 21614 21617 21617 21619 21623 TAL_Rep Street 624 Randall 532 Jackson 1626 Taylor TAL_Orders Order Date Customer Num 03/20/2014 148 03/20/2014 356 03/21/2014 408 03/21/2014 282 03/23/2014 608 03/23/2014 148 03/23/201 608 TAL_Order_Line Part Num AT94 DR93 DWII KL62 KT03 BV06 CD52 DR93 KV29 State Zip City Grove FL 33321 Sheldon FL 33553 Fillmore FL 33336 Num Ordered 11 1 1 4 2 2 4 1 2 Quoted Price $21.95 $495.00 $399.99 $329,95 $$95.00 $794.95 $190.00 $495.00 $1,290.00 Commission Rate $20.542.50 0.05 $39,216.00 0.07 $23.487.00 0.05 2

Answer rating: 100% (QA)

Youve presented three separate SQL queries and related data for a database concerning a company TAL The images also contain the data from the tables r... View the full answer