Q&A for developers and researchers interested in open data
SELECT Tags.TagName as TransportType, COUNT(DISTINCT Posts.Id) as QuestionCount, AVG(CAST(Posts.Score as FLOAT)) as AvgScore, SUM(Posts.ViewCount) as TotalViews FROM Posts LEFT JOIN PostTags ON Posts.Id = PostTags.PostId LEFT JOIN Tags ON PostTags.TagId = Tags.Id WHERE Tags.TagName IN ('air-travel', 'trains', 'car-rentals', 'public-transport', 'cruise') AND Posts.PostTypeId = 1 GROUP BY Tags.TagName ORDER BY QuestionCount DESC;