Databricks Certified Data Analyst - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data analyst has been asked to count the number of customers in each region and has written the following query:
SELECT
region,
COUNT(customer_id) AS customer_count
FROM customers
SELECT
region,
COUNT(customer_id) AS customer_count
FROM customers
If there is a mistake in the query, which of the following describes the mistake?
A
The query is using count(), which will count all the customers in the customers table, no matter the region.
B
The query is missing a GROUP BY region clause.
C
The query is using ORDER BY, which is not allowed in an aggregation.
D
There are no mistakes in the query.
E
The query is selecting region, but region should only occur in the ORDER BY clause.