Buildings with the most issues - Ziggu SQL Query - Peliqan

Buildings with the most issues

SQL query for Ziggu

Get the buildings with the highest number of reported issues in Ziggu.

SELECT buildings.name, COUNT(issues.id) AS total_issues FROM buildings JOIN issues ON buildings.id = issues.building_id GROUP BY buildings.name ORDER BY total_issues DESC LIMIT 10

Ziggu data model

Attachment Categories

Buildings

Companies

Customers

Decision Type Categories

Decision Types

Decisions

Documents

Employees

Fractions

Installments

Issue Categories

Issue List Types

Issue Lists

Issue Statuses

Issues

Lots

Messages

Partners

Phases

Projects

Proposals

Spaces

Ticket Categories

Tickets

Unit Customers

Units

Units Of Customer

Units Of Project

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.