Q&A for professional and enthusiast programmers
SELECT DisplayName, COUNT(*) AS UpVotes FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Votes ON Votes.PostId = Posts.Id and VoteTypeId = 2 INNER JOIN Users ON Posts.OwnerUserId = Users.Id WHERE lower(Location) like '%india%' --and DisplayName like '%Arun Palanisamy%' and Users.Id = ##usrid:int?4295763## GROUP BY DisplayName ORDER BY UpVotes DESC