Following table shows the delivery record of an online shop. Which of the SQL statements results in the largest value? Product ID Delivery Date…

Following table shows the delivery record of an online shop. Which of the SQL statements results in the largest value?

Product IDDelivery DateQuantity
F1012021-03-173
H2012021-03-172
F1012021-03-161
H2012021-03-162
  1. a) SELECT AVG(Quantity) FROM Delivery Record WHERE Product No. = 'F101'
  2. b) SELECT COUNT (*) FROM Delivery Record
  3. c) SELECT SUM (Quantity) FROM Delivery Record WHERE date = '2021-03-16'
  4. d) SELECT MAX (Quantity) FROM Delivery Record

From the Combined Bank Assistant Programmer (CSE) March 2021 – Preliminary exam, question 38 of 86.

More from this paper