这是创建表 和根据表里的数据添加进去呀的sql语句
1查询名人表中性别是男的作者作品
SELECT sname FROM celebrity where ssex="男";
查询静夜思的作者
方法一:select c.sname from celebrity c,works w,summary s where c.sid = s.sid and w.wid = s.wid and w.wwork = "静夜思";
方法二:select c.sname from summary s INNER join celebrity c on c.sid = s.sid
INNER join works w on w.wid = s.wid where w.wwork = "静夜思";
查询礼拜和杜甫的年级
S