Exam Databricks-Certified-Data-Analyst-Associate Topic 2 Question 45 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Analyst-Associate exam
Question #: 45
Topic #: 2

A data analyst wants the following output:
customer_name number_of_orders
John Doe 388
Zhang San 234
Which statement will produce this output?

A. SELECT customer_name, count(order_id) AS number_of_orders
FROM customers
JOIN orders
ON customers.customer_id = orders.customer_id
GROUP BY customer_name; B. SELECT customer_name, count(order_id) number_of_orders
FROM customers
JOIN orders
ON customers.customer_id = orders.customer_id USE customer_name; C. SELECT customerjiame, count(order_id)
FROM customers
JOIN orders
ON customers.customer_id = orders.customer_id GROUP BY customerjiame; D. SELECT customerjiame, (order_id) number_of_orders
FROM customers
JOIN orders
ON customers.customer_id = orders.customer_id;

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business