Question
Using the tables above, write SQL statements to answer the following; 1.List the number and name of each customer, together with the number, last name,
Using the tables above, write SQL statements to answer the following; 1.List the number and name of each customer, together with the number, last name, and first name of the sales rep who represents the customer.
2.List the number and name of each customer whose credit limit is $7,500, together with the number, last name, and first name of the sales rep who represents the customer.
3.For every part on order, list the order number, part number, part description, number of units ordered, quoted price, and unit price.
4.Find the description of each part included in order number 21610.
5.Find the order number and order date for each order that contains part number DR93.
6.Find the order number and order date for each order that includes a part located in warehouse 3.
7.List the customer number, order number, order date, and order total for each order with a total that exceeds $1,000. Assign the column name ORDER_TOTAL to the column that displays order totals.
8.List the number, last name, and first name for each sales rep together with the number and name for each customer the sales rep represents.
9.For each part on order, list the part number, number ordered, order number, order date, customer number, and customer name, along with the last name of the sales rep who represents each customer.
10.List the number and name of each customer that either is represented by sales rep 65 or that currently has orders on file, or both.
11.List the number and name of each customer that is represented by sales rep 65 and that currently has orders on file.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started