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:

Frontal Lobes

The regions of the brain located at the front, responsible for voluntary movement, expressive language, and managing higher level executive functions.

Parietal Lobes

Regions of the brain located behind the frontal lobes, important for processing sensory information regarding the location of parts of the body as well as interpreting visual information and processing language and mathematics.

Occipital Lobe

The area of the brain situated at the rear of the head, tasked with interpreting visual data received from the eyes.

Faculty Psychology

The theory that different mental abilities, such as reading and computation, are independent and autonomous functions carried out in different parts of the brain.