What are the truck ID’s of trucks that have carried small shipments. Small shipments are defined as those that weigh less than 8
1 answer:
Table for the question is attached in the picture below :
Answer:
SELECT distinct(TRUCK_ID), WEIGHT from SHIPMENT where WEIGHT < 800 ;
Step-by-step 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).
You might be interested in
Answer:
hope this helps.
They did not include the constraint for y ≤x+3 on the graph.
See attached picture with added constraint.
Using the 4 points that are given as the solution on the graph, replace t he x and Y in the original equation to solve and see which is the greater value.
Point (0,3) P = -0 +3(3) = 0+9 = 9
Point (1,4) P = -1 + 3(4) = -1 +12 = 11
Point (0,0) P = -0 + 3(0) = 0 + 0 = 0
Point (3,0) P = -3 + 3(0) = -3 + 0 = -3
The correct solution to maximize P is (1,4)
