Skip to main content

Peliqan

Try for free
Request a demo

Total revenue per product category

SQL query for Teamleader

Calculate the total revenue generated for each product category.

SELECT pc.name as product_category, SUM(i.total_amount) as total_revenue FROM productCategories pc LEFT JOIN invoices i ON pc.id = i.product_category_id GROUP BY pc.name

Try this query now in Teamleader

Teamleader data model

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