观察customers表的表结构，其中CUSTOMER_ID是表的主键。下列哪个选项能够查询出“Los Ang

单项选择题

观察customers表的表结构，其中CUSTOMER_ID是表的主键。下列哪个选项能够查询出“Los Angeles”和“San Francisco”的城市地址（city_address），以及每个城市里顾客的数量？（）

A.SELECT city_address，COUNT（*）FROM customers WHERE city_address IN （’Los Angeles’，’San Francisco’）；
B.SELECT city_address，COUNT（*）FROM customers WHERE city_address IN （’Los Angeles’，’San Francisco’）GROUP BY city_address；
C.SELECT city_address，COUNT（customer_id）FROM customers WHERE city_address IN （’Los Angeles’，’San Francisco’）GROUP BY city_address，customer_id；
D.SELECT city_address，COUNT（customer_id）FROM customers GROUP BY city_address IN （’Los Angeles’，’San Francisco’）；

Oracle