Top promotions
SQL query for Bol
Identify the top performing promotions based on the total revenue generated.
SELECT p.promotion_name, SUM(i.amount) as total_revenue FROM promotions p JOIN invoices i ON p.promotion_id = i.promotion_id GROUP BY p.promotion_name ORDER BY total_revenue DESC LIMIT 5
Bol data model
Promotions
Invoices
Inventory
Orders
Returns
Shipments
Replenishments
Products
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