按照出版社统计,各出版社的图书数量,出版社的字段为chubanshe?
group by chubanshe
select chubanshe 出版社 , count(1) 图书数量 from table group by chubanshe