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

Question

Options

• ASELECT order_type,COUNT(*) FROM orders WHERE order_type=order_type;
• BSELECT order_type,COUNT(*) FROM orders GROUP BY order_type;
• CCOUNT(SELECT order_type FROM orders);
• DSELECT COUNT(*) FROM orders ORDER BY order_type;
• ESELECT AUTO_COUNT FROM orders COUNT order_type;

• A
  14% (4)
• B
  71% (20)
• C
  7% (2)
• D
  4% (1)
• E
  4% (1)

No community discussion yet for this question.