List the sales rep ID, first name, last name, department ID, and department name for all sales reps whose commission cla

[answerhappygod]

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 38 times

List the sales rep ID, first name, last name, department ID, and
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