group by with inner join sqlserver

Question

 hi frnds i want to count how many shape in single category

plz solve this problem 

 ========================================

 

SELECT tbl_category.Category_Name, tbl_shape.Shape

FROM tbl_category

INNER JOIN

tbl_Image_Master ON tbl_category.Cat_Id = tbl_Image_Master.Cat_Id

INNER JOIN

tbl_shape ON tbl_Image_Master.Shape_Id = tbl_shape.ShapeId