Need help ASAP if someone can help me at b ustetl s retee theob 1. Write an SQL

Question

Need help ASAP if someone can help me

at b ustetl s retee theob 1. Write an SQL query on the TAL Distributors database that outputs the data shown below a. Sort output by Custmer Num, Ordec.Num b. Use the DBMS ERD (Fig. 1-7 in the text) as reference to set-up query. I cannot over-emphasize the importance of having the ERD handy-makes the job of setting-up queries a lot easier 2. What is the Primary Key (uniquely identifies a row) of this table? NUM QUOTED STOREH REP ORDEREDPRICE OUSE NUM CUSTOMER NAME ORDER NUM ORDER DATE NUM NUMDESCRIPTON 126 126 Toys Galore 260 Brookings Direct 334 The Everything Shop 334 The Everything Shop 386 Jahnson's Department Store516131013/2015 DLS1 586 586 586 586 586 796 Unique Gifts 51608 10/12/2015 CD33 Woad Block Set (48 piece] 86.991 15 121.95315 124.95330 10.951 45 $13.992 45 104.95330 116.95245 115.9345 29.952 45 $36.951 45 $13. 45.791 45 oys Galore 10/15/2015 FD11 Rocking Horse 1614 1013/2015 FD11 Rocking Horse 5161010/12/2015 KL78 Pick Up Sticks 516101012/2015 TR40 Tic Tac Toe 25 Railway Set Almondton General Store Almondton General Store Almondton General Store Almondton General Store Almondton General Store 5161710/15/2015 TW35 Fire Engine 51617 10/15/2015 NL89 Woad Block Set (62 piece) 1623 10/15/2015 DR67 1623 10/15/2015 FH24 P 516231015/2015 KD34 Pentominoes Brain Teaser tStar Brain Teaser Gift Set 12 45 10/16/2015 MTO3 Zauberkasten Brain Teaser

Explanation / Answer

1.

The above query will retrieve the customer table data sorted by customer num and order num.

2.

Based on the given question I have written answer , If you want anything else please comment it by clearly describing what you want from this question

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.