Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Macroeconomics

Authors: Lee Coppock, Dirk Mateer

2nd Edition

0393614093, 9780393614091

More Books

Students also viewed these Economics questions

Question

What are the responsibilities of the position?

Answered: 1 week ago