0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

with s as (
  select datepart(year, CreationDate) as year, datepart(month, CreationDate) as month from posts
)
select (year + CAST(month AS float) / 12) as chart_index,
  count(*) as count
from s
WHERE (month < 9 OR year < 2024)
group by year, month
order by year, month asc

fork query

edited sep 18

created sep 18 alphabet