mysql一对多题以及操作步骤

第一题：

1.查询名人表中性别是男的作者
SELECT * from celebrity as c where c.ssex='男'; 

2.查询静夜思的作者
select a1.sname,a2.wwork from summary a3 INNER JOIN celebrity a1 on a3.sid = a1.sid INNER JOIN works a2 on a3.wid = a2.wid where a2.wwork='静夜思';

3.查询李白和杜甫的年纪
select c.sname,c.sage from celebrity c  where c.sname = '李白' or c.sname='杜甫';

4. 查询名人表中的男女人数
select count(*),c.ssex from celebrity  c GROUP BY ssex;