设有关系R(A B C)和S(C D) 与关系代数表达式ΠA B D(σR C=S.C(R×S))等价的SQL语句是______。A.SELE

设有关系R(A,B,C)和S(C，D)，与关系代数表达式ΠA，B，D(σR,C=S.C(R×S))等价的SQL语句是______。

A．SELECT*FROMR，S WHERE R.C=S.C

B．SELECT A,B,D FROM R,S WHERE R.C=S.C

C．SELECT A,B,D FROM R,S WHERE R=S

D．SELECT A,B FROM R WHERE(SELECT D FROM S WHERE R.C=S.

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