Write a SQL query which will give the top 10 results (aggregated) from this data

- Website has a URL, Category and Text - URL has a Website - Text has Keywords and a URL - Keywords I want the top 10 Keywords by Category. This is the DB structure: Website: ID Domain (text) Categories (Many-to-Many via WebsiteCategories) // note in practice a website will only have one category, but it's still a many-to-many relationship WebsiteCategories: Website (FK) Category (FK) Category: ID Category (text) Url: ID Url (text) Website (FK) Text: ID Text (text) Keywords (Many-to-Many via TextKeywords) Urls (Many-to-Many on Url) TextKeywords: Text (FK) Keyword (FK) Keyword: ID Keyword (text) So you can see the route from Keyword to Category looks like this: Keyword -> TextKeywords -> Text -> Url -> Website -> WebsiteCategories -> Category I want you to give me something like this: Let's imagine the category is 2. Keyword ---- Count Keyword1 ---- 560 Keyword2 ---- 400 Keyword3 ---- 390 Keyword4 ---- 350 Keyword5 ---- 320 Keyword6 ---- 210 Keyword7 ---- 90 Keyword8 ---- 60 Keyword9 ---- 55 Keyword10 ---- 10 So as you can see, you are listing the keyword frequency by category, sorted by most frequent descending. Any questions, just ask.