Ziggu

Customers with the most units

SQL query for Ziggu

Get the customers with the highest number of purchased units in Ziggu.

SELECT customers.name, COUNT(units.id) AS total_units FROM customers JOIN unit_customers ON customers.id = unit_customers.customer_id JOIN units ON unit_customers.unit_id = units.id GROUP BY customers.name ORDER BY total_units 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

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.

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.

Peliqan Ask AI willl write your SQL queries from plain English