Most active users
SQL query for Whatsapp
List the top 10 most active phone numbers based on the number of messages sent.
SELECT phone_number, COUNT(*) AS message_count FROM Messages GROUP BY phone_number ORDER BY message_count DESC LIMIT 10
Whatsapp data model
Phonenumbers
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