请书写下面的SQL语句:
Student(Sid ,Sname,Sage,Ssex)学生表(学号,学生姓名,年龄,性别)
Course(Cid,Cname,Tid)课程表(课程编号,课程名,教师id)
SC(Sid,Cid,Score)成绩表(学号,课程编号,成绩)
SumTeacher(Tid,Tname)教师表(教师编号,教师名字)
1.查询平均成绩大于60分的学生的学号和平均成绩
select Sid,avg(Score)
from SC
group by Sid having avg(Score)>60
2.查询所有同学的学号,姓名,选课数,总成绩
select Student.Sid,Student.Sname,count(SC.Cid),sum(Score)
from Student left Outer join SC on Student.Sid=SC.Sid
group by Student.Sid,Sname
3.查询姓“李”的老师的个数
select count(distinct(Tname))
from Teacher
where Tname like '李%';
4.查询没有学过“叶平”老师课的同学的学号,姓名
select Student.Sid,Student.Sname
from Strudent
where Sid not in
(select distinct(SC.Sid)
from SC,Course,Teacher
where SC.Cid=Course.Cid and Teacher.Tid=Course.Tid and Teacher.Tname='叶平');