showing categorie and subcategories with counts to be shown

[myselfrandhawa]

Hi i have the following tables and i want to show categories and subcategories underneath them and count how many products exist in category and subcategory:
i am allowing multiple categories for a single product
table structure as:

productcategories

CREATE TABLE [dbo].[ProductCategories](
[prodID] [int] NULL,
[catID] [int] NULL,
[prodCatID] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK_ProductCategories] PRIMARY KEY CLUSTERED
(
[prodCatID] ASC

products

CREATE TABLE [dbo].[products](
[prod_id] [int] IDENTITY(1,1) NOT NULL,
[productName] [nvarchar](max) NULL,
[prodDesc] [nvarchar](max) NULL,
[productupdatedon] [datetime] NULL,
[prodShortDesc] [nvarchar](max) NULL,
[deleteRequested] [nchar](10) NULL CONSTRAINT [DF_products_deleteRequested] DEFAULT (N'No'),
CONSTRAINT [PK_products] PRIMARY KEY CLUSTERED
(
[prod_id] ASC

[acoder]

Use group by and count to get all the categories for each product and their counts