Tasks pending per user
SQL query for Zoho CRM
Count the number of pending tasks for each user.
SELECT user_id, COUNT(*) FROM tasks WHERE status = ‘Pending’ GROUP BY user_id
Zoho CRM data model
Users
Leads
Contacts
Deals
Tasks
Accounts
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