0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

select cast(p.creationdate as date) as dt, pt.tagid, sum(count(p.id))
over(partition by pt.tagid order by cast(p.creationdate as date)) from posts p
inner join posttags pt
on pt.postid=p.id
where p.creationdate>='2024-01-01'
and pt.tagid in (16,3,9,17,92497)
--where p.id>77740000
group by cast(p.creationdate as date), pt.tagid
order by pt.tagid, cast(p.creationdate as date)

view current version

edited sep 20

created sep 20 Janis123