Average invoice amount per company - Elina PMS SQL Query - Peliqan

Average invoice amount per company

SQL query for Elina PMS

Calculate the average invoice amount for each company.

SELECT company_id, AVG(amount) AS average_amount FROM sales_invoices GROUP BY company_id;

Elina PMS data model

Bookingrates

Persons

Companies

Payment Methods

Account Departments

Payments

Reservations

Areas

Inventory Types

Inventory Units

Inventory Ownership

Inventory Amenities

Inventory Unitcategory

Propertygroups

Sales Invoices

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.