查询同时选修课程号为C1和C5课程的学生的学号，正确的命令是（）。 A: <br/>SELECT学号FROMscorescWHERE课程号=&#39;C1&#39;AND学号IN<br/>(SELECT学号FROMscorescWHERE课程号=&#39;C5&#39;) B: <br/>SELECT学号FROMscorescWHERE课程号=&#39;C1&#39;AND学号=<br/>(SELECT学号FROMscorescWHERE课程号=&#39;C5&#39;) C: SELECT学号FROMscorescWHERE课程号=&#39;C1&#39;AND课程号=&#39;C5&#39; D: SELECT学号FROMscorescWHERE课程号=&#39;C1&#39;OR&#39;C5&#39;