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#;​

---

Definitions:

Uniform

Characterized by being the same in all situations, without variation or diversity in detail or condition.

Unimodal

A description of a distribution that has a single peak or mode; characterized by having one predominant value or central tendency.

Six-Sided Die

A common gaming object with six faces, each displaying a different number of dots from one to six.

Bimodal

Describing a distribution that has two distinct peaks or modes, indicating two prevalent values.