Skip to main content

Peliqan

Try for free
Request a demo

Bol

Inventory turnover

SQL query for Bol

Calculate the inventory turnover by dividing the total sales from orders by the average inventory level from inventory.

SELECT (SUM(o.total_amount) / AVG(i.inventory_level)) FROM orders o, inventory i

Try this query now in Bol

Bol data model

Bol
Promotions

Bol
Invoices

Bol
Inventory

Bol
Orders

Bol
Returns

Bol
Shipments

Bol
Replenishments

Bol
Products

Bol
Offers

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