Skip to main content

Peliqan

Try for free
Request a demo

AdminPulse

Total revenue per company

SQL query for AdminPulse

Calculate the total revenue generated by each company.

SELECT c.company_name, SUM(i.total_amount) AS total_revenue FROM companies c JOIN invoices i ON c.company_id = i.company_id GROUP BY c.company_id

Try this query now in AdminPulse

AdminPulse data model

AdminPulse
Invoices

AdminPulse
Relations

AdminPulse
Users

AdminPulse
Companies

AdminPulse
Tasks

AdminPulse
Documents

AdminPulse
Addresses

AdminPulse
Invoiceschedules

AdminPulse
Webhooks

AdminPulse
Assignmenttemplates

AdminPulse
Tasktemplates

AdminPulse
Teams

AdminPulse
Pricelistitems

AdminPulse
Pricetables

AdminPulse
Plannedregistrations

AdminPulse
Registrations

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