SQL Query HELP!!
Posted on 1998-12-02
Based off of the following:
CUSTOMER (CUST_ID(PRI-KEY), CUST_NAME,ANNUAL_REVENUE, CUST_TYPE)
SHIPMENT (SHIPMENT_#(PRI-KEY), CUST_ID(PRI-KEY),WEIGHT, TRUCK_#, DESTINATION, SHIP_DATE)
TRUCK (TRUCK_#(PRI-KEY), DRIVER_NAME)
CITY (CITY_NAME(PRI-KEY), POPULATION)
What would the SQL Queries be - based on the following questions??
What is the name of customer 433?
What is the destination city of shipment #3244?
List customers who have had shipments delivered by every truck.
What is the average weight of a shipment?
What is the average weight of a shipment going to Atlanta?
GROUP BY and HAVING:
For each customer, what is the average weight of a package
(shipment) sent by that customer?