The family as well as their dog________on the roof by the flood. [ ]

A. was  trapped    

B. trapped  

C. were  trapped    

D. trapping

关系R和S如下表所示，关系代数表达式Π1，4(R∞(下标)R.C＜S.B S)的结果为 (201) ，与该表达式等价的SQL语句为 (202) 。
R关系S关系

A．SELECTA，B FROM R，SWHERE C＜B
B．SELECT R．A，S．B From R，S WHERE R.C＜S.B
C．SELECT A，B FROM RWHERE C＜(SELECTB FROM S)
D．SELECT 1，5 FROM RWHERE C＜(SELECTB FROM S)

A
B
C
A
B
E
1
2
3
2
1
4
2
1
4
4
6
7
3
4
5
3
4
11
4
6
7
8
3
12