Which of the Following Is a Valid SQL Statement?​

question 34

Multiple Choice

Which of the following is a valid SQL statement?​

• A) ​SELECT SUM(quantity*retail)"Total Sales"
• FROM orders JOIN orderitems ON orders.order# = orderitems.order#
• JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
• WHERE orderdate = '02-APR-03';
• B) ​SELECT SUM(quantity*retail)"Total Sales"
• FROM orders JOIN orderitems ON orders.order# = orderitems.order#
• JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
• HAVING orderdate = '02-APR-03';
• C) ​SELECT customer#,SUM(quantity*retail)"Total Sales"
• FROM orders JOIN orderitems ON orders.order# = orderitems.order#
• JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
• HAVING orderdate = '02-APR-03';
• D) SELECT customer#,SUM(quantity*retail)"Total Sales"
• FROM orders JOIN orderitems ON orders.order# = orderitems.order#
• JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
• HAVING orderdate = '02-APR-03'
• GROUP BY customer#;​