sql - Aggregating data from Discourse -

i have sql query returns number of topics created in category each week.

select      count(*) topic_count,      date_trunc('week', created_at) week  topics      topics.deleted_at null ,      topics.category_id = (         select id          categories          categories.name 'category name'     )  group date_trunc('week', created_at) order week desc 

how can alter query can see topic_count each category in categories table? resulting columns see are:

• category 1 name topic count
• category 2 name topic count
• ...
• category n name topic count
• week

add category name query , group in addition week:

select      categories.name,     date_trunc('week', created_at) week      count(*) topic_count,  topics,      categories      topics.deleted_at null ,  , topics.category_id = categories.id , categories.name 'category name' group categories.name, date_trunc('week', created_at) order categories.name, week desc