Examine the description of the CUSTOMERS table: The CUSTOMER_ID column is the primary key for the table. Which statement returns the city address and the number of customers in the cities Los…

The correct answer is B. SELECT city_address, COUNT (*). Not C: The customer ID in the GROUP BY clause is wrong

Reporting Aggregated Data using the Group Functions

Question

Examine the description of the CUSTOMERS table:

The CUSTOMER_ID column is the primary key for the table. Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?

Exhibit

Options

ASELECT city_address, COUNT(*)
BSELECT city_address, COUNT (*)
CSELECT city_address, COUNT(customer_id)
DSELECT city_address, COUNT (customer_id)

How the community answered

(49 responses)

A
16% (8)
B
71% (35)
C
8% (4)
D
4% (2)

Explanation

Not C: The customer ID in the GROUP BY clause is wrong

Topics

#COUNT function#GROUP BY#IN clause#aggregate functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice