instruction: User Stats for Voting: Upvotes, Downvotes, Reputation & TotalPosts.
response: SELECT u.Id, u.Reputation, u.DisplayName, u.UpVotes, u.DownVotes, Q.TotalQs, A.TotalAs FROM Users AS u LEFT JOIN (SELECT COUNT(OwnerUserId) AS TotalQs, OwnerUserId FROM Posts WHERE PostTypeId = 1 GROUP BY OwnerUserId) AS Q ON u.Id = Q.OwnerUserId LEFT JOIN (SELECT COUNT(OwnerUserId) AS TotalAs, OwnerUserId FROM Posts WHERE PostTypeId = 2 GROUP BY OwnerUserId) AS A ON u.Id = A.OwnerUserId WHERE u.Id IN ('##UserId##')