sql语句

连接字符串：

String str = “server= .;database = scut18mse;integrated security = true”;

--查询2

select t.选课人数,t.平均分数from

(select count(*)'选课人数',avg(score)'平均分数' ,sc.cno'课程号'from sc

join course"c" onsc.cno = c.cno

group by sc.cno)"t"

join course"c" on t.课程号= c.cno

where c.cname = '{0}'

--查询2

select t.bname,t.借阅次数,b.publish from

(select bname,count(bname)'借阅次数' from lend"l"

join book"b" on l.bno = b.bno

group by bname )"t"

join book"b"

on t.bname = b.bname

order by t.借阅次数desc