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:

Accounts Payable

This term refers to the amounts owed by a company to suppliers or creditors for goods and services received but not yet paid for.

Sale Of Machinery

The process of transferring ownership of a piece of industrial equipment or machinery from one entity to another, usually in exchange for money.

Investing Activities

Transactions involving the purchase and sale of long-term assets and other investments not considered cash equivalents.

Increase

An upward change or rise in number, amount, value, or degree.