A shipping company needs to make sure they load packages into their truck according to the shipping priority each package has been given. However, if a package in the system has less than 3 days until it’s expected delivery date it should be loaded first. How would that get that result?
A
SELECT shipping_number FROM Packages WHERE days_left < 3 ORDER BY priority;
SELECT shipping_number FROM Packages WHERE days_left >= 3;
B
SELECT shipping_number FROM Packages WHERE days_left >= 3 ORDER BY priority;
SELECT shipping_number FROM Packages WHERE days_left < 3;
C
SELECT shipping_number FROM Packages WHERE days_left < 3;
SELECT shipping_number FROM Packages WHERE days_left >= 3 ORDER BY priority;
D
SELECT shipping_number FROM Packages WHERE days_left >= 3;
SELECT shipping_number FROM Packages WHERE days_left <= 3 ORDER BY priority;