instruction: Total # questions and # closed/deleted questions posted by 1-rep accounts.
response: SELECT u.Id AS "user_link", COUNT(q.Id) AS "Number of questions" FROM Users AS u LEFT JOIN Posts AS q ON q.PostTypeId = 1 AND q.OwnerUserId = u.Id WHERE u.Reputation = 1 GROUP BY u.Id ORDER BY COUNT(q.Id)