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

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

Product IdDateQuantity
F1012020-10-173
H2012020-10-172
F1012020-10-161
H2012020-10-162
  1. a) SELECT AVG(Quantity) FROM Delivery Record WHERE Product id='F101'
  2. b) SELECT COUNT (*) FROM Delivery Record
  3. c) SELECT SUM (Quantity) FROM Delivery Record WHERE Date = '2020-10-16'
  4. d) SELECT MAX (Quantity) FROM Delivery Record

From the Janata Bank Assistant Network Engineer 2020 – Written exam, question 32 of 68.

More from this paper