Using the Tal Distrbutors Database from A Guide To SQL (9th Edition), List all t

Question

Using the Tal Distrbutors Database from A Guide To SQL (9th Edition), List all the customer representatives and their corresponding customers. Include the representative’s last name and the customer name, order by the rep's last name in descending order.

Schema:

?eject Browser ? ? c ?127.0.0.1:8080/apex/f?p-4500:1001:645686924296311-NO::: ORACLE Application Express welcome SYSTEM I Logout ? Home Application Bulder SQL Workshop - Hame S0L Workshop Object Browser Scherma LAL ' Help Tatles Create ? APEXS ACL APEXS_WS FILES WS HSTORY APEXS WS LINKS APEXS WS NOTES APLXS_Ws ROWS APEXS WS TAGS APEKS WS WEBPG SECTIONS DEMO CUSTOMERS DEMO ORDERS DEMO ORDER ITEMS DEMO PRODUCT DEMO STATES DEMO USERS DEPT HTMLDB PLAN REP Appication Lxpress 4.0 2.00.09 Wolapac TAL Uaer SYSTEM Language en Copynght &1330, 2010, Crade All rihts eserved

Explanation / Answer

Select Rep.LastName,Customer.CustomerName from Customer inner join Rep on Customer.RepNum = Rep.RepNum order by Rep.LastName desc;

or

Select Rep.LastName,Customer.CustomerName from Customer , Rep where Customer.RepNum = Rep.RepNum order by Rep.LastName desc;

Do ask if any doubt. Pelase upvote.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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