Skip to main content

Peliqan

Try for free
Request a demo

Sales by customer and product

SQL query for NetSuite

Get sales data by customer and product.

SELECT c.name as customer_name, p.product_name, SUM(s.amount) as total_sales FROM customer c JOIN sales s ON c.customer_id = s.customer_id JOIN product p ON s.product_id = p.product_id GROUP BY c.name, p.product_name

Try this query now in NetSuite

NetSuite data model

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