表2:作者(作者姓名、作者编号、年龄、性别)
两张表为:
books(id,title,address,date)
author(no,name,age,sex)
SQL语句为:
SELECT
author.`name`,books.title,
author.`name`,
books.address
FROM
books
INNER JOIN author ON books.authorid = author.no
no
WHERE
author.age < (SELECT AVG(age) FROM author);
好奇是不是要把中文换成全英文。
select aname,bname,pub from anthor a join book b on (a.ano = b.ano) where age < (select avg(age) from author)
这道题你会答吗?花几分钟告诉大家答案吧!
扫描二维码,关注牛客网
下载牛客APP,随时随地刷题