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

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

A SELECT AVE(Quantity)FROM Delivery Record WHERE Product No='F101'

B SELECT COUNT (*)FROM Delivery Record

C Select SUM FROM Delivery Record WHERE data ='2021-03-16'.

D SELECT MAX(Quantity)FROM Delivery Record

Solution

Correct Answer: Option D