Quick SQL question! Sort by most occurences of an attribute
Hi guys I have two tables as such:

Categories:
ID - Name - Desc

Items
ID - Name - CategoryID - Desc - Price

I want a query that returns a list of categories ranked by most occurences in the items table
Quick SQL question! Sort by most occurences of an attribute
===

Hi guys I have two tables as such:

Categories:
ID - Name - Desc

Items
ID - Name - CategoryID - Desc - Price

I want a query that returns a list of categories ranked by most occurences in the items table