Lab #9 – Joining Data From Multiple Tables List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator. Lab #10 – Sub Queries Find the sales rep number, last name, and first name for every sales rep who represents at least one customer with a credit limit of $2000. List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Down below are the tables ORDER_LINE ORLN_ORDER_NUMBER ORLN_PART_NUMBER ORLN_NUMBER_ORDERED ORLN_QUOTED_PRICE ORDER_TABLE ORDR_ORDER_NUMBER ORDR_ORDER_DATE ORDR_CUSTOMER_NUMBER CUSTOMER CUST_NUMBER CUST_LAST CUST_FIRST CUST_STREET CUST_CITY CUST_STATE CUST_ZIP_CODE CUST_BALANCE CUST_CREDIT_LIMIT CUST_SALES_REP_NUM PART PART_NUMBER PART_DESCRIPTION UNITS_ON_HAND ITEM_CLASS WAREHOUSE UNIT_PRICE SALES_REP SLSR_PK SLSR_LAST SLSR_FIRST SLSR_STREET SLSR_CITY SLSR_STATE SLSR_ZIP_CODE SLSR_TOTAL_COMMISSION SLSR_COMMISSION_RATE
Lab #9 – Joining Data From Multiple Tables
List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator.
Lab #10 – Sub Queries
Find the sales rep number, last name, and first name for every sales rep who represents at least one customer with a credit limit of $2000.
List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron.
Down below are the tables
ORDER_LINE
ORLN_ORDER_NUMBER
ORLN_PART_NUMBER
ORLN_NUMBER_ORDERED
ORLN_QUOTED_PRICE
ORDER_TABLE
ORDR_ORDER_NUMBER
ORDR_ORDER_DATE
ORDR_CUSTOMER_NUMBER
CUSTOMER
CUST_NUMBER
CUST_LAST
CUST_FIRST
CUST_STREET
CUST_CITY
CUST_STATE
CUST_ZIP_CODE
CUST_BALANCE
CUST_CREDIT_LIMIT
CUST_SALES_REP_NUM
PART
PART_NUMBER
PART_DESCRIPTION
UNITS_ON_HAND
ITEM_CLASS
WAREHOUSE
UNIT_PRICE
SALES_REP
SLSR_PK
SLSR_LAST
SLSR_FIRST
SLSR_STREET
SLSR_CITY
SLSR_STATE
SLSR_ZIP_CODE
SLSR_TOTAL_COMMISSION
SLSR_COMMISSION_RATE
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
