CompTIA
LX0-104 · Question #119
Which of the following SQL queries counts the number of occurrences for each value of the field order_type in the table orders?
Sign in or unlock LX0-104 to reveal the answer and full explanation for question #119. The question stem and answer options stay visible for context.
Shells, Scripting and Data Management
Question
Which of the following SQL queries counts the number of occurrences for each value of the field order_type in the table orders?
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;
Unlock LX0-104 to see the answer
You've previewed enough free LX0-104 questions. Unlock LX0-104 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL#GROUP BY#aggregate functions#database querying