The average response time for most popular tags (with at least one vote)
Q&A about the site for enthusiasts and power users of the Android operating system
-- Average response time by tags -- The average response time for most popular tags (with at least one vote) declare @limit int = 100; declare @tag_name nvarchar(35) = 'snowflake-cloud-data-platform'; declare @tag_id int = (select id from tags where tagname = @tag_name); SELECT Posts.Id, Tags.Id, Posts.CreationDate FROM Posts INNER JOIN Tags ON Posts.Id=Tags.Id;