List of questions of a given user

1

Please login or register to vote for this query.

(click on this box to dismiss)

Worldbuilding

Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings

SELECT * FROM (
SELECT
q.OwnerUserId,
u.DisplayName AS UserName, 
count(*) as Nquestions,
sum(q.Score) AS TotalVotes,
round(sum(q.Score)/(1.0*count(*)),2) AS AverageVotes
FROM
  Posts q
  inner join Users u ON q.OwnerUserId = u.Id
WHERE q.PostTypeId = 1
group by q.OwnerUserId, u.DisplayName) a
where a.Nquestions > 10 
ORDER BY a.AverageVotes DESC, a.Nquestions DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results