Question

What are the truck ID’s of trucks that have carried small shipments. Small shipments are defined as those that weigh less than 800 pounds? (HInt: Avoid duplcates.)

Answer 1

Table for the question is attached in the picture below :

Answer:

SELECT distinct(TRUCK_ID), WEIGHT from SHIPMENT where WEIGHT < 800 ;

Explanation:

The Structured query language (SQL) defined above, returns only the TRUCK_ID and Weight column from the shipment table as they are the only two columns listed after the select keyword. The condition is added using the WHERE keyword on the weight table, this filters the result returned to include only rows where the weight value is less than 800. The distinct keyword used alongside the TRUCK_ID column ensures that a certian TRUCK_ID value isn't returned more than once (Hence, it is used to avoid duplicates).