Top selling products
SQL query for Billit
Identify top selling products based on quantity sold.
SELECT products.product_name, SUM(invoiceLines.quantity) AS total_quantity_sold FROM products JOIN invoiceLines ON products.product_id = invoiceLines.product_id GROUP BY products.product_name ORDER BY total_quantity_sold DESC LIMIT 5
Billit data model
Parties
Account Information
Documents
Invoices
Invoice Lines
Products
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.
- 14-day free trial
- No credit card needed