instruction: unaccepted question rate, grouped by user. for each person who has asked a question on the site, display the userid and their unaccepted-question percentage (their Q's that have no accepted answer divided by their Q's; where Q's are further filtered to be 'not closed' and 'at least one answer')
response: SELECT Users.Id AS "user_link", Posts.Id AS "post_link" FROM Users JOIN Posts ON Posts.OwnerUserId = Users.Id WHERE Posts.ClosedDate IS NULL AND Posts.AnswerCount > 0 LIMIT 50