10 minutes I'm pretty sure. My calculations may be off but at least I tried
Question 7
(37,065 - 26, 102)/(37, 065) = P/100
(10, 963)/(37, 065) = P/100
37, 065P = (10, 963)(100)
37,065P = 109, 630
P = 109, 630 ÷ 37, 065
P = 2.9577768785
P = 295.78%
Do likewise for the rest of the questions.
To change from decimal to percent, move the decimal point two places to the right and then add the percent symbol (%).
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).
LCM - means least common multiple