Created by samliew (http://stackoverflow.com/users/584192/samuel-liew)
Q&A for people studying math at any level and professionals in related fields
-- https://data.stackexchange.com/stackoverflow/query/edit/761631 SELECT TOP 100 Users.Id as [User Link] , Users.DisplayName , COUNT (atags.Id) AS Number_of_Tags, Users.Reputation, ( select distinct t.tagname + ', ' AS 'data()' from tags t inner join posttags pt on pt.tagid = t.id inner join posts p on pt.postid in (p.id, p.parentid) where p.owneruserid = Users.Id AND LOWER(t.tagname) LIKE 'react%' FOR XML PATH('') ) as ksdjkv FROM tags atags inner join posttags pt on pt.tagid = atags.id inner join posts p on pt.postid in (p.id, p.parentid) INNER JOIN Users ON Users.Id = p.owneruserid WHERE LOWER(atags.tagname) LIKE 'react%' AND LOWER(Users.Location) LIKE 'malaysia' GROUP BY Users.Reputation, Users.DisplayName, Users.Id ORDER BY Users.Reputation DESC --// could PostTags