Exam4Training

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

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;

Answer: B

Latest 102-500 Dumps Valid Version with 194 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version