Q&A for experienced flyers, pilots, and builders of drones and model aircraft
SELECT TagName, SUM(case votes.votetypeid WHEN 2 THEN 1 -- upvote WHEN 3 THEN -1 -- downvote END) as Rep, Users.DisplayName as UserName, number = ROW_NUMBER() OVER (ORDER BY TagName), Users.Reputation, Users.CreationDate, Users.DisplayName, Users.LastAccessDate, Users.WebsiteUrl, Users.Location, Users.ProfileImageUrl FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Users ON Posts.OwnerUserId = Users.Id INNER JOIN Votes ON Votes.PostId = Posts.Id WHERE (Tags.TagName LIKE 'java%' or Tags.TagName LIKE 'js%') AND Posts.CommunityOwnedDate IS NULL AND Users.Location Like 'Wars%' and Users.WebsiteUrl like 'http%' and Users.Reputation >= 500 GROUP BY TagName, DisplayName, Users.Reputation, Users.CreationDate, Users.DisplayName, Users.LastAccessDate, Users.WebsiteUrl, Users.Location, Users.ProfileImageUrl ORDER BY Rep DESC