5. Note categories with the most notes
SQL query for Vitally.io
Identify note categories with the highest number of notes.
SELECT note_category_id, COUNT(*) AS note_count FROM notes GROUP BY note_category_id ORDER BY note_count DESC
Vitally.io data model
Accounts
Conversations
Custom Objects
Notes
Note Categories
Nps Responses
Organizations
Projects
Project Templates
Tasks
Task Categories
Users
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