Q&A about the site for enthusiasts and scholars of mythology and folklore
SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], u.Id AS [User Link], u.Reputation, count(p.id) FROM Users u inner join posts p on p.ownerUserid = u.id inner join posttags pt on pt.postid = p.id inner join tags t on t.id = pt.tagid WHERE (LOWER(Location) LIKE LOWER('%kochi%') OR LOWER(Location) LIKE LOWER('%trivandram%') OR LOWER(Location) LIKE LOWER('%koratty%')) and ( t.tagname='html' OR t.tagname='css' OR t.tagname='css3' OR t.tagname='html5' OR t.tagname='bootstrap' ) group by u.reputation, u.id ORDER BY Reputation DESC;