Write a query to display the customer number, last name and first name for every

Question

Write a query to display the customer number, last name and first name for every customer represented by sales rep 15 or sales rep 20.

(TCO 6) Write a query to display the customer number, last name and first name for every customer represented by sales rep 15 or sales rep 20 SalesRep PK ReplD int Customer PK CustomerlD int LastName FirstName CommissionRatedecimal(10,2) varchar(20) varchar(20) LastName varchar(20) FirstName varchar(20) Street City State Zipcode Balance varchar(20) varchar(20) char(2) char(5) decimal(10,2) int Order PK OrderlD int FK1 ReplD FK1 CustomerlD int OrderDate date ShipDate date Part PK PartID int OrderLine Description varchar(20) UnitsOnHandint ItemClass Retail Cost PK,FK1 OrderlDint PK,FK2 PartlD int char(4) decimal(10,2) decimal(10,2) Quantity int

Explanation / Answer

SELECT CustomerID,LastName,FirstName

FROM Customer

WHERE RepID = 15 or RepId = 20;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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