Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?

Examine the description of the CUSTOMERS table:

CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
STREET_ADDRESS VARCHAR2(150)
CITY_ADDRESS VARCHAR2(50)
STATE_ADDRESS VARCHAR2(50)
PROVINCE_ADDRESS VARCHAR2(50)
COUNTRY_ADDRESS VARCHAR2(50)
POSTAL_CODE VARCHAR2(12)
CUSTOMER_PHONE VARCHAR2(20)
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(customer_id)
FROM customers
WHERE city_address IN (‘Los Angeles’, ‘San Francisco’)
GROUP BY city_address, customer_id;

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

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

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

Explanation:

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