Total sales amount for each project - Simplicate SQL Query - Peliqan

Total sales amount for each project

SQL query for Simplicate

Get the total sales amount for each project.

SELECT pr.name AS project_name, SUM(s.amount) AS total_sales_amount FROM projects pr LEFT JOIN sales s ON pr.id = s.project_id GROUP BY pr.id

Simplicate data model

Organization Industries

Organizations

Organization Sizes

Person Genders

Relation Types

Employee Civil Statuses

Employee Contract Types

Employee Types

Employment Types

Employees

Webhooks

Webhook Logs

Countries

Persons

Sales

Sales Services

Sales Service Hour Types

Sales Service Cost Types

Vatcodes

Costtypes

Deafult Services

Revenuegroup

Organization Profiles

Hour Types

Webhook Actions

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.