Top 5 contacts with the highest call duration
SQL query for Aircall
Find the top 5 contacts with the highest total call duration in the Calls table.
SELECT contact_id, SUM(call_duration) AS total_call_duration FROM Calls GROUP BY contact_id ORDER BY total_call_duration DESC LIMIT 5
Aircall data model
Calls
Contacts
Users
Calls Summary
Calls Topics
Calls Sentiments
Calls Transcription
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