在以下语句中，哪些是查询t1表中北京和上海的相关记录
A.        select * from t1 where city_name = "北京" or city_name = "上海";


B.        select * from t1 where city_name = "北京" and city_name = "上海";


C.        select * from t1 where city_name in ("北京","上海");


D.        select * from t1 where city_name in "北京" or "上海";
题库