List the part number, part description, and units on hand of all parts whose number of units on 

              hand is more than average. 

2.           Determine the most expensive part in the database. The MAX function should also be used.

3.           Use the IN operator to find the customer number, last name and first name for every customer 

              who placed an order on September 5, 2018. 

4.           Repeat the exercise from the prior step using the EXISTS operator. 

5.           Find the customer number, last name, and first name for every customer who did not place an 

              order on September 5, 2018. 

6.           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. 

7.           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. 

8.           List the order number and order date for every order that was placed by Mary Nelson and that 

              does not contain an order line for an iron. Use a SELECT and a sub SELECT instruction set.

9.           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 ALL operator in the

query. 

10.        Repeat the exercise from the prior step using the ANY operator in the query instead of the ALL 

              operator.

Transcribed Image Text:

CUST_CUSTOMER_NUMBER CUST_LAST CUST_FIRST CUST_STREET CUST_CITY CUST_STATE CUST_ZIP_CODE CUST_BALANCE CUST_CREDIT_LIMIT CUST_SALES REP_NU 481 Oak 239 Drive Lansing MI Edison 215 Pete 48 College 124 239 256 311 315 405 412 522 567 587 622 Adams (Yours) Samuels Charles Daniels Tom Willians Al Adams Nelson Dinah Galvin Sally (Yours) Ann Don Martins Sally Mary Tran Mara Dan 914 Cherry 519 Watson 16 Elm 108 Pine ses Ridge 512 Pine 419 Chip Grant Ira Kent Grant Lansing Ada Harper Ada Grant MI MI MI MI MI MI MI MI MI MI 49224 8618 49219 49034 46391 49219 49224 49441 49421 49441 49219 818.75 1000 21.5 825.75 770.75 402.75 1817.5 98.75 402.4 114.6 1045.75 1000 3000 1500 1000 750 1500 2000 1500 750 1000 1000 3 12 6 12 6 12 3 12 6 6 3 CUST_CUSTOMER_NUMBER CUST_LAST CUST_FIRST CUST_STREET CUST_CITY CUST_STATE CUST_ZIP_CODE CUST_BALANCE CUST_CREDIT_LIMIT CUST_SALES REP_NU 481 Oak 239 Drive Lansing MI Edison 215 Pete 48 College 124 239 256 311 315 405 412 522 567 587 622 Adams (Yours) Samuels Charles Daniels Tom Willians Al Adams Nelson Dinah Galvin Sally (Yours) Ann Don Martins Sally Mary Tran Mara Dan 914 Cherry 519 Watson 16 Elm 108 Pine ses Ridge 512 Pine 419 Chip Grant Ira Kent Grant Lansing Ada Harper Ada Grant MI MI MI MI MI MI MI MI MI MI 49224 8618 49219 49034 46391 49219 49224 49441 49421 49441 49219 818.75 1000 21.5 825.75 770.75 402.75 1817.5 98.75 402.4 114.6 1045.75 1000 3000 1500 1000 750 1500 2000 1500 750 1000 1000 3 12 6 12 6 12 3 12 6 6 3