0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of web applications

select
cast(creationDate as Date) as created,
count(*) as total
from posts
inner join posttags on posts.id = posttags.postid
inner join tags on posttags.tagid = tags.id
where tags.tagname like '%ruby%'
group by cast(creationDate as Date)
order by created asc

fork query

edited jun 15 21

created jun 15 21 Dathan