These tables have already been created. just needing the mySQL queries the quest
ID: 3917363 • Letter: T
Question
These tables have already been created. just needing the mySQL queries the questions ask for.
CUSTOMER CUSTOMER STREET CITY STATE ZIP BALANCE CREDIT REP NUM LIMIT NUM Fillmore FL 33336 $6 550.0O $7,500.00 20 Al's Appliance 2837 and Sport reenway 148 Brookings 3827 Devon Groe FL 33321 $431.5 S10,000,00 35 356 Ferjuson's 382 Wildwood Northfield FL 33146 $5,785.00 $7,500.00 65 1828 Raven Crystal FL33503 $5,285.25 $5,000.00 35 3829 Central Growe FL 33321 $3,412.00 $10,000.00 65 838 Ridgeland Fillmore FL 33336 $12,762.00 $15,000,00 20 Johason's 372 OxfordSheldon FL33553 $2,106.00 $10,000,00 65 Lee's Sport 282 Evengreen Altonville FL 32543 $2,85100 $5,000.00 35 Deerfield's 282 Columbia Sheldon FL 33553 $248.00 $7,500.00 35 Four Seasons All Season 28 Lakeview Growe ORDERS ORDER LINE OADER NUM PART NUM NUM OADERED QUOTED PRICE 21608 21610 NUM DATE AT94 $21.95 21608 $495.00 1220007 356 21613 122007 408 21614 |10W21/20071282 21617 122007 608 23/2007 148 1623 1232007 608 DV11 21613 21614 21617 21617 21619 $329.95 $595.00 $79495 KTOJ 21619 $495.00 1.290.00 FIGURE 2-1 Sample data for Premiere Products (continued) REP REP LAST FIRST STREET CITY STATE ZIP COMMISSION RATE NUM NAME NAME 20 Kaiser Valeric624 Randall Grove FL 35 Hull Richard 532 Jackson Sheldon FL 3332 $20,542.50 0.05 3553$39,216.00 0.07 65 Perez Juan 1626 Taylor Fillmore FL 33336 $23,487.00 005 FIGURE 2-1 Sample data for Premiere Products PART PART NUM DESCRIPTION ON HAND CLASS WAREHOUSE PRICE $24.95 $794.95 $165.00 $129,95 $495.00 $399.99 $159.95 $349.95 $595.00 $1,390.00 IW3 45 8G 2 2 AP 21 HW3 AT94 Home Gym Microwave Oven Cordless Drill Gas Range Washer Stand Mixer D4.71 SIAP DW11 12 AP 12 AP 1 KTO3 81 AP KV29Explanation / Answer
Please Note: As per Chegg Answering Guidelines, I have answered the first 4 sub questions/queries. Please Post Separate for other Questions to be answered.
Answer)
7. For each order list the order number, order date, part number, part description, item class for each part that makes up the order.
SELECT Orders.Order_Num, Orders.Order_Date, Order_Line.Part_Num, Part.Part_Description, Part.Class
FROM ((Orders
INNER JOIN Order_Line ON Orders.Order_Num = Order_Line.Order_Num)
INNER JOIN Part ON Order_Line.Part_Num = Part.Part_Num);
8. Same as 7 order by item class and then by order number.
SELECT Orders.Order_Num, Orders.Order_Date, Order_Line.Part_Num, Part.Part_Description, Part.Class
FROM ((Orders
INNER JOIN Order_Line ON Orders.Order_Num = Order_Line.Order_Num)
INNER JOIN Part ON Order_Line.Part_Num = Part.Part_Num)
order by Part.Class,Orders.Order_Num;
9. Use subquery to find rep number, last name, first name of each sales rep who represents at least one customer with a credit limit of $5000.
select rep_num, last_name, first_name from Rep where Rep_Num in(
select distinct Rep_Num from Customer where balance > 5000
);
10. Exercise 9 but without subquery.
select distinct Rep.Rep_Num, Rep.last_name, Rep.first_name from Rep inner join Customer Rep.rep_num=Customer.Rep_Num;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.