SQL

Discussion in 'OT Technology' started by twinturboteddy, Aug 31, 2007.

Thread Status:
Not open for further replies.
  1. twinturboteddy

    twinturboteddy Bling Bling!

    Joined:
    Jul 3, 2000
    Messages:
    1,056
    Likes Received:
    0
    Location:
    San Gabriel, Ca, USA
    [​IMG]

    Write a sub query that will list the part number, part description, and units on hand of all parts where the number of units on hand is greater than the average of units on hand for all parts.

    Using a NATRUAL JOIN method, write a query that will list the customer number, last name, and first name for every customer who currently has an order on file for an iron.

    For every order, list the order number, order date, part number, part description, and item class for each part that makes up the order.

    In SQL. Thanks!
     
  2. Nocera

    Nocera ...

    Joined:
    Aug 9, 2000
    Messages:
    1,307
    Likes Received:
    0
    Location:
    Long Island, NY
    Umm... No.
     
Thread Status:
Not open for further replies.

Share This Page