Simplicate

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

Simplicate
Table Persons
Id: String
Note: String
Gender: String
Initials: String
Full_name: String
Gender_id: String
Is_active: Boolean
Address_id: String
Created_at: Date-time
First_name: String
Updated_at: Date-time
Family_name: String
Address_type: String
Avatar_color: String
Date_of_birth: String
Simplicate_url: String
Address_country: String
Avatar_initials: String
Relation_type_id: String
Custom_salutation: String
Address_country_id: String
Family_name_prefix: String
Relation_type_label: String
Address_country_code: String
Use_custom_salutation: Boolean
Timeline_email_address: String

Simplicate
Table Organizations

Simplicate
Table Contactpersons

Simplicate
Table Hours

Simplicate
Table Employees

Simplicate
Table Timetables

Simplicate
Table Leaves

Simplicate
Table Projects

Simplicate
Table Project Services

Simplicate
Table Invoices

Simplicate
Table Sales

Simplicate
Table Genders

Simplicate
Table Hourstypes

Simplicate
Table Leavetypes

Use SQL on all your SaaS data

Magical SQL for Simplicate with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Peliqan Ask AI willl write your SQL queries from plain English