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

Using Functions (Single-Row, Group, Conversion, Conditional)

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

(48 responses)

A
4% (2)
B
77% (37)
C
13% (6)
D
6% (3)

Explanation

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

Topics

#COUNT#GROUP BY#WHERE clause#aggregate functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice