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: 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(*) FROMcustomers WHERE city_address IN ( ‘Los
Angeles’, ‘San Fransisco’);

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

C.
SELECT city_address, COUNT(customer_id) FROMcustomers WHERE city_address IN
( ‘Los Angeles’, ‘San Fransisco’) GROUP BYcity_address, customer_id;

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