Thanks Ashok!:-) Appreciated.Ater thinking a little bit, I came up with this updated query:

select pr.prodduct_id,pr.product_name from Product pr join

( select product_id,count(state_id) as [States Count] from Restriction group by...