Which statement returns the city address and the number…

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?

A.
SELECT city_address, COUNT(*)
FROM. customers
WHERE city_address IN ( ‘Los Angeles’, ‘San Fransisco’);

B.
SELECT city_address, COUNT (*)
FROM. customers
WHERE city address IN ( ‘Los Angeles’, ‘San Fransisco’)
GROUP BY city_address;

C.
SELECT city_address, COUNT(customer_id)
FROM. customers
WHERE city_address IN ( ‘Los Angeles’, ‘San Fransisco’)
GROUP BY. city_address, customer_id;

D.
SELECT city_address, COUNT (customer_id)
FROM . customers
GROUP BY city_address IN ( ‘Los Angeles’, ‘San Fransisco’);

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