Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles
SELECT q.ViewCount AS views, q.Title AS title, q.Body AS body, q.Tags AS tags, q.CreationDate AS creation_date, u.DisplayName AS user_display_name, u.Id AS user_id, u.Reputation AS user_reputation, u.Location AS user_location, u.WebsiteUrl AS user_website, a.Body AS top_answer_body, a.CreationDate AS top_answer_creation_date FROM Posts q JOIN Users u ON q.OwnerUserId = u.Id JOIN Posts a ON q.Id = a.ParentId WHERE q.Tags LIKE '%android-management-api%' AND q.PostTypeId = 1 AND a.PostTypeId = 2 -- Filter for answers only AND a.Score = (SELECT MAX(Score) FROM Posts WHERE ParentId = q.Id) -- Filter for top answers ORDER BY q.ViewCount DESC;