LPI Exam 102-500 Topic 10 Question 4 Discussion

Actual exam question for LPI's 102-500 exam

Question #: 4
Topic #: 10

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

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;

Show Suggested Answer

Suggested Answer: B

by Jettie at May 06, 2022, 11:30 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!