Which of the Following SQL Queries Counts the Number of Occurrences

question 101

Multiple Choice

Which of the following SQL queries counts the number of occurrences for each value of the field order_type in the table orders?

• A) SELECT order_type,COUNT(*) FROM orders WHERE order_type=order_type;
• B) SELECT order_type,COUNT(*) FROM orders GROUP BY order_type;
• C) COUNT(SELECT order_type FROM orders);
• D) SELECT COUNT(*) FROM orders ORDER BY order_type;
• E) SELECT AUTO_COUNT FROM orders COUNT order_type;

---

Definitions:

High School

is an educational institution that provides secondary education, typically for students aged approximately 14 to 18.

Substance Abuse Problems

Issues arising from the excessive and harmful use of psychoactive substances, including alcohol and illicit drugs, negatively impacting an individual's health and social functioning.

People

Human beings considered collectively, often within a specific context such as a community, nation, or demographic group.

Over

This term is too broad and lacks context for a specific definition in this list.