Joining to the same table with different filters – Telegram API
I am trying to count, for each id, the number of distinct app downloaded by the user, grouping the count by category. An example of the separate queries are as such: SELECT id ,COUNT(DISTINCT app) AS gaming_apps FROM apps_table WHERE…