ZOHO Invoice

Top Selling Items

SQL query for ZOHO Invoice

Get the top selling items based on quantity sold.

SELECT items.item_name, SUM(invoice_lines.quantity) AS Total_Quantity_Sold FROM invoice_lines JOIN items ON invoice_lines.item_id = items.item_id GROUP BY items.item_name ORDER BY Total_Quantity_Sold DESC LIMIT 10

ZOHO Invoice data model

ZOHO Invoice
Table Items

ZOHO Invoice
Table Pricebooks

ZOHO Invoice
Table Contacts

ZOHO Invoice
Table Recurringinvoices

ZOHO Invoice
Table Estimates

ZOHO Invoice
Table Customerpayments

ZOHO Invoice
Table Creditnotes

ZOHO Invoice
Table Expenses

ZOHO Invoice
Table Recurringexpenses

ZOHO Invoice
Table Projects

ZOHO Invoice
Table Users

ZOHO Invoice
Table Expensecategories

ZOHO Invoice
Table Taxes

ZOHO Invoice
Table Currencies

ZOHO Invoice
Table Invoices

ZOHO Invoice
Table Invoice Lines

Use SQL on all your SaaS data

Magical SQL for ZOHO Invoice 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