用SQL语句，根据booktype,book表，创建一个包含ISBN,booktitle,auth

Question

用SQL语句，根据booktype,book表，创建一个包含ISBN,booktitle,author,typename,press,price的视图

Answer 1

/*帮你把语句排了下序，层次显得明显一点，也简单的注释下（主要是也不清楚你每张表以及字段各代表什么意思），不懂的追问*/

select *
from (select bookid, count(bookid) as degree
from tb_borrow
group by bookid) as borr --统计tb_borrow表中bookid各有多少条
join (select b.*,c.name as bookcasename,p.pubname,t.typename
from bookinfo b --基础表bookinfo
left join tb_bookcase c on b.bookcase = c.id --左链接tb_bookcase
join tb_publishing p on b.ISBN = p.ISBN --内链接tb_publishing
join tb_booktype t on b.typeid = t.id --内链接tb_booktype
where b.del = 0) as book
on borr.bookid = book.id --外层内链接两张中间表追问

create view --
as select --
from --
像这种简单语句的话应该怎么写呢