instruction: Question statistics for a single user.
response: SELECT 'Questions', COUNT(*) FROM Posts WHERE OwnerUserId = '##UserId:int##' AND PostTypeId = 1 UNION ALL SELECT 'Questions without accepted answer', COUNT(*) FROM Posts WHERE OwnerUserId = '##UserId:int##' AND PostTypeId = 1 AND AcceptedAnswerId IS NULL UNION ALL SELECT 'Unanswered questions', COUNT(*) FROM Posts WHERE OwnerUserId = '##UserId:int##' AND PostTypeId = 1 AND AnswerCount = 0 UNION ALL SELECT 'Resolved questions', COUNT(*) FROM Posts WHERE OwnerUserId = '##UserId:int##' AND PostTypeId = 1 AND AcceptedAnswerId > 0