ZOHO Invoice

Total revenue by month

SQL query for ZOHO Invoice

Calculate the total revenue for each month.

SELECT DATE_FORMAT(invoice_date, %Y-%m) AS month, SUM(total_amount) AS revenue FROM outgoinginvoices GROUP BY month

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