Number of installations per month

SQL query for Robaws

Count the number of installations completed each month.

SELECT DATE_FORMAT(completion_date, ‘%Y-%m’) AS month, COUNT(*) AS total_installations FROM Installations GROUP BY month ORDER BY month

Robaws data model

Table Work Orders

Table Vat Tariffs

Table Transports

Table Transport Supply Orders

Table Time Registrations

Table Tasks

Table Supply Orders

Table Supplier Contacts

Table Suppliers

Table Subscriptions

Table Subcontractor Supply Orders

Table Stock Reservations

Table Stock Locations

Table Stock Changes

Table Offer Settlement Parameters

Table Offer Settlement Line Item Parameters

Table Offer Settlement Line Items

Table Settlements

Table Sales Order Line Items

Table Sales Orders

Table Sales Invoice Line Items

Table Sales Invoices

Table Rental Supply Orders

Table Recurrence Types

Table Purchase Supply Orders

Table Purchase Invoice Line Items

Table Purchase Invoices

Table Project Construction Partners

Table Projects

Table Project Supply Routes

Table Price Request Supply Orders

Table Price Groups

Table Post Parameters

Table Posts

Table Planning Types

Table Planning Item Line Items

Table Planning Items

Table Place Transports

Table Payment Conditions

Table Offers

Table Mobility Types

Table Materials

Table Legal Forms

Table Journals

Table Internal Supply Orders

Table Installations

Table Import Jobs

Table General Ledger Accounts

Table Employees

Table Employee Certificates

Table Employee Role

Table Documents

Table Delivery Notes

Table Delivery Note Line Items

Table Contacts

Table Companies

Table Comments

Table Clients

Table Cash Registers

Table Cash Register Closings

Table Cash Entries

Table Bank Payments

Table Articles

Table Article Tier Price

Table Article Suppliers

Table Article Groups

Table Activities

Table Absences

Table V A T Check

Table Users

Table Claim States

Table Claim States Line Items

Table Project Statistics

Table Work Order Time Entries

Table Work Order Material Entries

Table Work Order Line Items

Table Work Order Commute Entries

Table Project Phases

Table Post Calculation Line Items

Table Offer Phases

Table Client Contacts

Magical SQL for Robaws 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.

Number of installations per month

SQL query for Robaws

Robaws data model

Magical SQL for Robaws with Peliqan.io

Let AI do the work for you

Ready to get instant access to all your company data ?

Ready to get instant access to
all your company data ?