instruction: Average question score vs Average answer score.
response: SELECT questions.OwnerUserId, qs, qavg, 'as', aavg, UpVotes - DownVotes AS deltavote FROM (SELECT OwnerUserId, COUNT(OwnerUserId) AS qs, AVG(Score) AS qavg FROM Posts WHERE PostTypeId = 1 GROUP BY OwnerUserId) AS questions INNER JOIN (SELECT OwnerUserId, COUNT(OwnerUserId) AS "as", AVG(Score) AS aavg FROM Posts WHERE PostTypeId = 2 GROUP BY OwnerUserId) AS answers ON questions.OwnerUserId = answers.OwnerUserId INNER JOIN Users ON Users.Id = questions.OwnerUserId ORDER BY qavg DESC LIMIT 1000