Refer to Schema A. Which query correctly shows only the tota…
Refer to Schema A. Which query correctly shows only the total quantity for order ID 5001? A ) SELECT SUM(T.qty) FROM tblORDER T WHERE T.orderID = 5001; B ) SELECT SUM(T.qty) FROM tblORDER T GROUP BY T.orderID HAVING T.orderID = 5001; C ) SELECT T.qty FROM tblORDER WHERE T.orderID = 5001; D ) SELECT SUM(T.qty) FROM tblORDER WHERE T.orderID = 5001;
Read Details