0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

SELECT 'https://travel.stackexchange.com/questions/' + CONVERT(VARCHAR, Posts.Id) as url, (ViewCount / NULLIF((SELECT -DATEDIFF(DAY, GETDATE(), CreationDate)), 0)) AS avg_views_per_day, Title,
Score,
ViewCount,
CreationDate
FROM Posts
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
WHERE TagName IN ('booking', 'online-booking', 'expedia')
AND ViewCount > 1000 ORDER BY Score DESC;

fork query

edited dec 9

created dec 9 anonymous