0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain

-- Query 4: Alternative Accommodation Analysis
-- Helps understand vacation rental trends (relevant to Question 2)
SELECT 
    Tags.TagName,
    COUNT(DISTINCT Posts.Id) as QuestionCount,
    AVG(CAST(Posts.Score as FLOAT)) as AvgScore,
    COUNT(DISTINCT Answers.Id) as AnswerCount
FROM Posts
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
LEFT JOIN Posts Answers ON Posts.Id = Answers.ParentId
WHERE Tags.TagName IN ('airbnb', 'vacation-rentals', 'apartments', 'hotels', 'hostels')
    AND Posts.PostTypeId = 1
GROUP BY Tags.TagName
ORDER BY QuestionCount DESC;

fork query

edited dec 6

created dec 6 anonymous