Ziggu

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

Ziggu
Table Units

Ziggu
Table Companies

Ziggu
Table Customers

Ziggu
Table Documents

Ziggu
Table Employees

Ziggu
Table Lots

Ziggu
Table Projects

Ziggu
Table Installments

Ziggu
Table Buildings

Ziggu
Table Unit Customers

Ziggu
Table Fractions

Ziggu
Table Issues

Ziggu
Table Issue Lists

Ziggu
Table Issue List Types

Ziggu
Table Issue Categories

Ziggu
Table Issue Statuses

Ziggu
Table Phases

Ziggu
Table Attachment Categories

Use SQL on all your SaaS data

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

Peliqan Ask AI willl write your SQL queries from plain English

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.