Advertisement
Roageev

Untitled

Mar 22nd, 2024
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.30 KB | Fixit | 0 0
  1. SELECT EXTRACT(MONTH FROM DATE_TRUNC('MONTH', creation_date::DATE)),
  2.        SUM(views_count) AS views_cnt
  3. FROM stackoverflow.posts
  4. WHERE EXTRACT(YEAR FROM DATE_TRUNC('year', creation_date::DATE)) = '2008'
  5. GROUP BY EXTRACT(MONTH FROM DATE_TRUNC('MONTH', creation_date::DATE))
  6. ORDER BY views_cnt DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement