Number of leaves taken by each employee

SQL query for Simplicate

Get the count of leaves taken by each employee.

SELECT p.first_name || || p.last_name AS employee_name, COUNT(l.id) AS total_leaves_taken FROM persons p INNER JOIN employees e ON p.id = e.person_id LEFT JOIN leaves l ON e.id = l.employee_id GROUP BY e.id

Simplicate data model

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

Table Costs Coststype

Table Costs Expense

Table Crm Contactperson

Table Crm Country

Table Crm Debtor

Table Crm Document

Table Crm Gender

Table Crm Industry

Table Crm Interests

Table Crm Organization

Table Crm Person

Table Crm Relationtype

Table Customfields Model

Table Documents Document

Table Documents Document Type

Table Hours Approval

Table Hours Hours

Table Hours Hourstype

Table Hrm Absence

Table Hrm Civilstatus

Table Hrm Contract

Table Hrm Employee

Table Hrm Leave

Table Hrm Team

Table Hrm Timetable

Table Invoices Document

Table Invoices Invoice

Table Invoices Payment

Table Invoices Proposition

Table Invoices Vatclass

Table Projects Assignment

Table Projects Document

Table Projects Project

Table Projects Project Customfields

Table Projects Purchasetype

Table Projects Service

Table Sales Sales

Table Sales Salesprogress

Table Sales Salessource

Table Sales Service

Table Services Defaultservice

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 such as Microsoft Power BI, Tableau or Metabase.

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.