Question: Create SQL data manipulation statements for the following queries. Customer ( CustomerNumber, CustomerName, Street, City, State, Zip, Balance, CreditLimit, SalesRepNumber ) SalesRep ( RepNumber, LastName,
Create SQL data manipulation statements for the following queries.
Customer ( CustomerNumber, CustomerName, Street, City, State, Zip, Balance, CreditLimit, SalesRepNumber ) SalesRep ( RepNumber, LastName, FirstName, Street, City, State, Zip, Commision, Rate ) Based on the codes above: List each customers number and name, along with the number, last name and first name of each customers sales rep.
Customer ( CustomerNumber, CustomerName, Street, City, State, Zip, Balance, CreditLimit, SalesRepNumber ) SalesRep ( RepNumber, LastName, FirstName, Street, City, State, Zip, Commision, Rate )
Based on the codes above: For each customer whose credit limit is $10,000, list the customers number and name, along with the number, last name, and first name of the corresponding sales rep.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
