Write the SQL command for the following quires:

  • customer (customer_number, last, first, street, city, state, balance, credit_limit)
  • orders (order_number, customer_number, part_number, slsrep_number, number_ordered, quoted_price)
  • order_line (order_number, part_number, number-ordered, quoted_price)
  • parts (part_number, part_description, units_on_hand, item_class, warehouse_number, unit_price)
  • sales_rep (slsrep_number, last, first, street, city, state, zip_code, commission_rate)
  • List all the order numbers and the total dollars of each order.
  • List customer’s name and number who bought the largest order.
  • List the sales person name and number who sold the least.
  • List the first , last and city for every sales-rep who sold a part that came out of warehouse # 3 and costs more than the average unit_price.
  • List the part number , part description, on-hand value for every part that has on-hand value greater than 200
  • Create table order_Line and insert one record into it.
Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.