0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people seeking specific software recommendations

SELECT 
'https://stackoverflow.com/questions/' + CONVERT(VARCHAR, Posts.Id) as url,
(
ViewCount / (SELECT -DATEDIFF(DAY, GETDATE() , CreationDate))
) AS ave_views_per_day,
*
FROM 
Posts 
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
WHERE TagName IN ('google-bigquery')
AND ViewCount > 10000 -- set to some sensible value
-- ORDER BY ave_views_per_day DESC
ORDER BY Score DESC

fork query

edited dec 6

created dec 6 anonymous