Sort by Two Column

Situation: You have a Month and Day column and you want to sort both in descending order.

Note: the last line.

SELECT
  user_name,
  month,
  day,
  COUNT(content) AS content_count
FROM cte 
GROUP BY 1,2,3
ORDER BY month DESC, day DESC;

For more content on Data and DAOs find me on Twitter.

Last updated on Dec 3, 2021