Top clients by declarations
SQL query for Fiscaal Gemak
Get the top 10 clients with the highest number of declarations.
SELECT client_id, COUNT(*) AS num_declarations FROM client_declarations GROUP BY client_id ORDER BY num_declarations DESC LIMIT 10;
Fiscaal Gemak data model
Clients
Relations
Declarations
Contactperson
Deliveries
Workflows
Externaldeclarations
Deferral
Declaration Updates
Steplist
Trial Balance
Itemstates
Externaldeclarationdocuments
Partnerrelations
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