sql多表联查练习题

select *
from celebrity
order by sage limit 0,2

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

select *
from celebrity c
where c.ssex= '男'

 

2.查询静夜思的作者 

select 
c.sname
from 
celebrity c
inner join summary s on c.sid=s.sid 
inner join works w on w.wid = s.wid
where 1=1
and w.wwork = '静夜思'

3.查询李白和杜甫的年纪

select 
c.sname,
c.sage
from 
celebrity c
where 1=1
and c.sname = '李白'
or c.sname = '杜甫'

 4.