数据库SQL语言习题求助！

1select ssno,ssname from s,c,sc where ssno=scsno and ccno=sccno and ccname="MS"

2select ssno from s,sc where ssno=scsno and sccno="c1" or ssno=scsno and sccno="c2" group by ssno

3select ssno,scgrade from s,c,sc where ssno=scsno and ccno=sccno and ccname=" *** 作系统" or ccname="数据库课程"

4select ssno,ssname,sage from s where ssex="女" and sage >=18 and sage <= 20

5select ssno,ssname,scgrade from s,c,sc where ssno=scsno and ccno=sccno and cteacher="刘平"

6select ssname,sage,sSD from s where ssname="李%"

7select ssname,sage,sSD,count() as 统计 from s,sc where ssno=scsno and 统计 >3 group by ssno

打那么多不容易再追加点分吧

1select 职工职工号, 姓名 from 职工,社会团体 ,参加 where 职工职工号=参加职工号 and 参加编号 in (select 编号from 社会团体 where 名称='歌唱队' or 名称='篮球队')

2 select 职工号, 姓名 from 职工,社会团体 ,参加 where 职工职工号=参加职工号 and 参加编号not in (select 编号from 社会团体)

3select 职工职工号, 姓名 from 职工,社会团体 ,参加 where 职工职工号=参加职工号 and 参加编号 in (select 编号from 社会团体)

瞌睡吖,睡啦,明个再写吧

1 select '类别为：'+tushuleibie 图书分类 from T_Book

2 select shuming 书名,zuozhe 作者,jiage07 价格 from T_Book where chubanshe ='机械工业出版社'

3 select shuming 书名,zuozhe 作者,jiage 价格, chubanshe 出版社 from T_Book where jiage between 30 and 60

4 select top 3 shuming 书名,zuozhe 作者,chubanshe 出版社, jiage 价格 from T_Book order by jiage desc

6select chubanshe 出版社,AVG(jaige) 平均价,MAX(jiage) 最高价 ,MIN(jaige) 最低价 from T_Book group by chubanshe order by SUM(jiage) desc

10select top 1 chubanshe 出版社, count() 出版图书个数 from T_Book group by chubanshe order by COUNT() desc

book表的做好了 reader的自己做吧 字段名我用拼音做代替的 你自己替换成你表中的字段

以上就是关于数据库SQL语言习题求助！全部的内容，包括:数据库SQL语言习题求助！、数据库查询语言方面的题、sql 数据库习题谢谢等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！