语法格式可以概括为:
select * FROM (表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号) INNER JOIN 表3 ON 表1.字段号=表3.字段号
-- 1.查询名人表中性别是男的作者
SELECT * FROM celebrity WHERE ssex='男';
-- 2.查询静夜思作者
SELECT celebrity.sname FROM summary inner join celebrity ON celebrity.sid=summary.sid inner join works on works.wid=summary.wid WHERE works.wwork='静夜思';
-- 3.查询李白和杜甫的年纪
SELECT sage FROM celebrity WHERE sname='李白' or sname='杜甫';
-- 4.查询名人表中的男女人数
SELECT sum(case when ssex ='男' then 1 else 0 end)男,sum(case when ssex='女' then 1 else 0 end)女 FROM celebrity;
-- 5.查询白居易作品名称和对应的名句
SELECT works.wwork,summary.sassess FROM summary inner join celebrity on celebrity.sid=summary.sid inner join works on works.wid=summary.wid WHERE celebrity.sname='白居易';
-- 6.查询年纪在25到30岁之间的个数
SELECT SUM(celebrity.sage BETWEEN 25 AND 30) FROM c