Câu 17: Databricks Certified Data Analyst Associate

A data analyst has been asked to count the number of customers in each region and has written the following query: If there is a mistake in the query, which of the following describes the mistake?

1. A. The query is using count(*), which will count all the customers in the customers table, no matter the region.
2. B. The query is missing a GROUP BY region clause. — đáp án hiện tại
3. C. The query is using ORDER BY, which is not allowed in an aggregation.
4. D. There are no mistakes in the query.
5. E. The query is selecting region, but region should only occur in the ORDER BY clause.