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;

题解

SELECT 叙述可以使用 GROUP BY 关键字来合并重复的字段,答案是选项 B。