Question: 1 . List the part number, part description, and units on hand of all parts whose number of units on hand is more than the
List the part number, part description, and units on hand of all parts whose number of units on
hand is more than the average units on hand.
Determine the least expensive part in the database. List the part number, part name, and part pricel. The MIN function should be used.
Use the EXISTS operator to find and display the customer number, last name, first name, and order date for every customer who placed an order after September
Find the customer number, last name, first name, and order date for every customer who did not place an order on September
Find the sales rep number, last name, first name for every sales rep who represents at least
one customer with a credit limit of $
List the order number, order date, last name, first name, and part description for every order that was placed by Mary Nelson and that does not contain an order line for an iron.
List the part number, part description, unit price, and item class for every part that has a unit
price greater than the unit price of any part in item class HW Use the ANY operator in the
query.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
