Top 5 users by activity count
SQL query for Docebo
Get the top 5 users with the highest activity count.
SELECT user_id, COUNT(*) AS activity_count FROM user_activities GROUP BY user_id ORDER BY activity_count DESC LIMIT 5;
Docebo data model
Users
User Activities
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed