Total number of entries in each list
SQL query for Attio
Get the count of entries for each list in the database.
SELECT lists.name, COUNT(entries.id) as entry_count FROM lists LEFT JOIN entries ON lists.id = entries.list_id GROUP BY lists.name
Attio data model
Companies
Deals
Lists
Objects
Notes
People
Tasks
Entries
Users
Workspaces
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