急急急！数据库这几道题怎么写啊？求大神协助，感激！！ 30
1个回答
展开全部
select top 5 book_name,book_price from books order by book_price desc
select book_type,max(book_price) as 最高价,min(book_price) as 最低价,avg(book_price) as 平均价
from books group by book_type
3. select books.book_name,authors.author_name
from books left outer join authors on books.author_id=authors.author_id
4.select books.book_name
from books left outer join authors on books.author_id=authors.author_id
where datediff(getdate(),author_birthday)>=40
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
