List the sales rep ID, first name, last name, department ID, and department name for all sales reps whose commission cla
Posted: Mon May 02, 2022 12:22 pm
- List The Sales Rep Id First Name Last Name Department Id And Department Name For All Sales Reps Whose Commission Cla 1 (45.25 KiB) Viewed 40 times
department name for all sales reps whose commission class is
‘A.’ Concatenate the first and last names together, using
SalesRep_Name as the column heading. Sort by department ID
then by sales rep ID.
PRODUCT 1 ProdID ProdName ProdCatID ProdPrice ORDERDETAIL 1 OrderID 1 ProdID ProdQty ProdPrice ORDER 9 OrderID OrderDate CustID CUSTOMER CustID CustName Custl Name CustPhone SalesRepID PRODCAT 1 ProdCatID ProdCatName COMMISSION 1 CommClass CommRate SALESREP SalesRepID SalesRepFName SalesRepl.Name CommClass Deptid al DEPARTMENT Deptid DeptName