查询各个商品分类中各有多少商品的SQL语句

SELECT goods_category_id ,count(*) FROM `sw_goods` group by goods_category_id