Query editor
1SELECT 2 SUM(order_revenue) as "Total Revenue"3FROM (4 SELECT 5 order_id, 6 SUM(total_order_amount) - SUM(total_order_discount) AS order_revenue7 FROM dune.nodeops.dataset_nodeops_orders8 GROUP BY order_id9) AS per_order;10
SELECT
SUM(order_revenue) as "Total Revenue"
FROM (
order_id,
SUM(total_order_amount) - SUM(total_order_discount) AS order_revenue
FROM dune.nodeops.dataset_nodeops_orders
GROUP BY order_id
) AS per_order;