（1）SELECT * FROM C WHERE CNAME LIKE '%数据库%'（2）SELECT a.[S#],a.SNAME FROM S a LEFT JOIN SC b ON a.[S#] = b.[S#] LEFT JOIN C ON b.[C#] = c.[C#] WHERE c.CNAME = 'MATHS'（3）SELECT a.[S#],a.SNAME,SUM(CASE WHEN ISNULL(b.C#,'') = '' THEN 0 ELSE 1 END) AS [课程门数] FROM S a LEFT JOIN SC b ON a.[S#] = b.[S#]GROUP BY a.[S#],a.SNAME（4）SELECT SNAME,AGE FROM S WHERE [S#] = '03240115'（5）SELECT b.GRADE FROM S a LEFT JOIN SC b ON a.[S#] = b.[S#] LEFT JOIN C ON b.[C#] = c.[C#] WHERE c.CNAME = '数据库原理' AND a.SNAME = '王芳'是不是要这样？

1.select eno,ename,age from emp where job_title="高" and gender=1
2.
3.
4.
5.select emp.dno,dname count(dno) as 部门人数 from emp,dept where emp.dno=dept.dno group by 1 order by 1
6.select emp,dno,,dname,average(salary) 平均工资 from emp,dept where emp.dno=dept.dno group by 1,2 order by 1 having 平均工资>3000