EasyBasic SELECT

Show total revenue from all orders

The query

SQL

SELECT
  SUM(total) AS total_revenue,
  COUNT(*) AS order_count,
  ROUND(AVG(total), 2) AS avg_order_value
FROM orders
WHERE status = 'completed';

Tested against PostgreSQL 16

Note

“Multiple aggregates can be computed in a single query pass.