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 出版社

)