单选题
已知关系模式:R(a, b, c)和S(d, e, f),创建如下视图: CREATE VIEW theView AS SELECT a,’cs145’ AS class,f FROM R,S WHERE R.b = S.e; 并执行下列查询Q: SELECT a FROM theView WHERE theView.f>10; 以下哪个查询与Q结果相同?
A、SELECT a FROM R,S WHERE R.class =’cs145’ AND S.f>10;
B、SELECT a FROM R NATURAL JOIN S WHERE S.f>10;
C、SELECT a FROM R, S WHERE R.b= S.e AND S.f>10;
D、SELECT a FROM theView,S WHERE S.f>10.