instruction: unsolved Q's asker's Info [Consider Bounty](Q is not closed yet).
response: SELECT pUser.OwnerUserId AS askerId, u.DisplayName AS askerName, COUNT(pUser.OwnerUserId) AS caseCnt, u.Reputation AS askerReputation, u.UpVotes AS askerUpVotes, u.DownVotes AS akserDownVotes, SUM(v.bountyOnce) AS bountyCaseCnt FROM (SELECT OwnerUserId, Id FROM Posts WHERE PostTypeId = 1 AND AcceptedAnswerId IS NULL AND ClosedDate IS NULL) AS pUser LEFT OUTER JOIN (SELECT PostId, VoteTypeId, 1 AS bountyOnce FROM Votes WHERE VoteTypeId = 8 GROUP BY PostId, VoteTypeId) AS v ON pUser.Id = v.PostId JOIN Users AS u ON pUser.OwnerUserId = u.Id GROUP BY pUser.OwnerUserId, u.DisplayName, u.Reputation, u.UpVotes, u.DownVotes ORDER BY caseCnt DESC