若要查询评论了mID 为‘m001’和‘m002’两部电影的评论者rID 则能够得到正确结果的SQL语句是——

A．SELECT rID FROM Rating WHERE mid=’m001’ AND mid=’m002’

B．SELECT rID FROM Rating WHERE mid=’m001’ OR mid=’m002’

C．SELECT rID FROM Rating WHERE mid=’m001’ UNION SELECT rID FROM Rating WHERE mid=’m002’

D．SELECT rID FROM Rating WHERE mid=’m001’ INTERSECT SELECT rID FROM Rating WHERE mid=’m002’

请帮忙给出正确答案和分析，谢谢！