多表联查的使用

一.

1.查询名人表中性别是男的作者

select sname from biao1 where ssex="男";

2.查询静夜思的作者
select biao1.sname from biao1 inner join biao3 on biao1.sid=biao3.sid inner join biao2 on biao2.wid=biao3.wid where wwork="静夜思";

3.查询李白和杜甫的年纪
select sage from biao1 where sname="李白" or sname="杜甫";

4.查询名人表中的男女人数
select ssex,count(ssex) from biao1 group by ssex;

5.查询查询白居易写的作品名称和对应名句
select biao2.wwork,biao3.sassess from biao1 inner join biao3 on biao1.sid=biao3.sid inner join biao2 on biao2.wid=biao3.wid where sname="白居易";

6.查询年纪在25到30岁之间的个数
select count(*)from biao1 where sage between 25 and 30;

7.查询名人表中年纪最小两条的数据信息
select * from biao1 order by sage limit 0,2;

8.查询李白的作品名称,名句和年纪
select  biao1.sage,biao2.wwork,biao3.sassess from biao1 inner join biao3 on biao1.sid=biao3.sid inner join biao2 on biao2.wid=biao3.wid where snam