-4

I would like to know who has asked the most number of questions and how many they asked.

0
5

The Stack Exchange Data Explorer (SEDE) can answer such questions for you. Fortunately someone's already written such a query.

In fact quite a lot of people did so you can pick any of those queries that work for you and run them.

The query itself would look something like this...

SELECT
  u.Id, u.DisplayName, COUNT(*) AS NumPosts
FROM Posts p
  INNER JOIN Users u ON u.Id = p.OwnerUserId
WHERE
  p.PostTypeId = 1
GROUP BY U.Id, U.DisplayName
ORDER BY NumPosts DESC
0

Not the answer you're looking for? Browse other questions tagged .