在下列代码中，（ ）可以正确显示蓝梅所选修的课程名。
选项：

A:SELECT cname FROM S,SC,C WHERE S.sno=S
C:sno AND S
C:cno=
C:cno AND SNAME='蓝梅';
B:SELECT cname FROM S JOIN SC ON S.sno=S
C:sno JOIN C ON S
C:cno=
C:cno WHERE SNAME='蓝梅';
C:SELECT cname FROM S NATURAL JOIN SCNATURAL JOIN C WHERE SNAME='蓝梅';
D:SELECT cname FROM C WHERE Cno in ( SELECT cno FROM SC WHERE Sno in ( SELECT sno FROM S WHERE sname='蓝梅' ) );