Question

sql题目，创建视图，统计各出版社出版的图书数量。

求大神解答，感激不尽

Answer 1

假设原来的图书表名为book，出版社列名为publish，图书编号列名为book_id，要创建的视图名称为vbook，则代码如下：
create view vbook(publish, bookcount)
as
select publish, avg(book_id)
from book
group by publish

Answer 2

CREATE VIEW AS (
SELECT 出版社,sum(图书数量) GROUP BY 出版社

)