instruction: Unresolved questions with answers by user.
response: SELECT COUNT(P.Id) AS "Questions", COUNT(P2.Id) AS "Unresolved", 10000 * COUNT(P2.Id) / COUNT(P.Id) / 100.0 AS "Percent", MIN(U.DisplayName) AS "Who", MIN(U.Reputation) AS "Rep", YEAR(MIN(U.CreationDate)) AS "Joined", YEAR(MIN(U.LastAccessDate)) AS "Last Seen" FROM Posts AS P LEFT JOIN Users AS U ON P.OwnerUserId = U.Id LEFT JOIN Posts AS P2 ON P.Id = P2.Id AND P2.AcceptedAnswerId IS NULL WHERE P.AnswerCount > 0 GROUP BY U.Id ORDER BY 'Unresolved' DESC, 'Percent' DESC