Total number of reservations per month
SQL query for Elina PMS
Get the total number of reservations made each month.
SELECT EXTRACT(MONTH FROM created_at) AS month, COUNT(*) AS total_reservations FROM reservations GROUP BY EXTRACT(MONTH FROM created_at) ORDER BY month;
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.
- 14-day free trial
- No credit card needed