How to get number of solutions per users using Data Explorer?

When a user solves a topic, an entry is added to the user_actions table with its action_type set to 15.

The following query should give you what you are looking for:

SELECT
user_id,
COUNT(1) AS solved_count
FROM user_actions
WHERE action_type = 15
GROUP BY user_id
ORDER BY solved_count DESC