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
Persons
View 26 columns
IdString
NoteString
GenderString
InitialsString
Full_nameString
Gender_idString
Is_activeBoolean
Address_idString
Created_atDate-time
First_nameString
Updated_atDate-time
Family_nameString
Address_typeString
Avatar_colorString
Date_of_birthString
Simplicate_urlString
Address_countryString
Avatar_initialsString
Relation_type_idString
Custom_salutationString
Address_country_idString
Family_name_prefixString
Relation_type_labelString
Address_country_codeString
Use_custom_salutationBoolean
Timeline_email_addressString
Costs Coststype
Costs Expense
Crm Contactperson
Crm Country
Crm Debtor
Crm Document
Crm Gender
Crm Industry
Crm Interests
Crm Organization
Crm Person
Crm Relationtype
Customfields Model
Documents Document
Documents Document Type
Hours Approval
Hours Hours
Hours Hourstype
Hrm Absence
Hrm Civilstatus
Hrm Contract
Hrm Employee
Hrm Employee Customfields
Hrm Leave
Hrm Team
Hrm Timetable
Invoices Document
Invoices Invoice
Invoices Payment
Invoices Proposition
Invoices Vatclass
Projects Assignment
Projects Document
Projects Project
Projects Project Customfields
Projects Purchase
Projects Purchasetype
Projects Service
Sales Sales
Sales Salesprogress
Sales Salessource
Sales Service
Services Defaultservice
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