Q&A for gardeners and landscapers
-- Users in Denmark who answered questions about Objective-C -- Tag1: Tag 1 "Questions include ([Tag 1] or [Tag 2]) and [Tag 3]. Write them in lowercase" -- Tag2: Tag 2 (optional) "Questions include ([Tag 1] or [Tag 2]) and [Tag 3]. Write them in lowercase" -- Tag3: Tag 3 (optional) "Questions include ([Tag 1] or [Tag 2]) and [Tag 3]. Write them in lowercase" -- UsersCountry: Users Country "Users location" -- QuestionsDate: Questions Date "Questions dates are from this date forward" -- AnswersDate: Answers Date "Answers dates are from this date forward" -- UsersLastAccessDate: Users Last Access "Users last logged-in date are from this date forward" SELECT ROW_NUMBER() OVER(ORDER BY COUNT(*) DESC, u.Reputation DESC) AS #, u.Id AS [User Link], COUNT(*) AS Answers#, u.Reputation, FORMAT(u.LastAccessDate, 'yyyy') AS [Last Access] FROM (Posts AS q INNER JOIN Posts AS a ON q.Id = a.ParentId) INNER JOIN Users AS u ON a.OwnerUserId = u.Id WHERE q.Tags LIKE '%flutter%' AND u.Location LIKE '%%' AND q.CreationDate >= ##QuestionsDate:string?2000-01-01## AND a.CreationDate >= ##AnswersDate:string?2000-01-01## AND u.LastAccessDate >= ##UsersLastAccessDate:string?2000-01-01## GROUP BY u.Id, u.Reputation, u.LastAccessDate