12.查询姓“李”的老师的个数;
select count(distinct(Tname)) from Teacher where Tname like ‘李%’;
13.查询所有课程成绩小于60分的同学的学号、姓名;
select S_ID,Sname from Student where S_ID not in (select S.S_ID from Student AS S,SC where S.S_ID=SC.S_ID and score>60);
14.查询至少有一门课与学号为“1001”的同学所学相同的同学的学号和姓名;
select distinct S_ID,Sname from Student,SC where Student.S_ID=SC.S_ID and SC.C_ID in (select C_ID from SC where S_ID=‘1001’);