How it workstop_productsSELECT product_id, count() AS sales FROM eventsWHERE event = ‘buy’GROUP BY product_idORDER BY sales DESCtop_products_endpointSELECT title, sales, sales*price as revenuesFROM o top_productsJOIN o products using product_idORDER BY {{column(order_by, ‘sales’)}} DESCLIMIT {{Int8(limit, 10, required=True)}}Simplify complex queriesBy splitting your query in different nodes you simplify development and maintenance.Enrich your data and add custom logic Use
