text: -- database: presto; groups: tpch; tables: customer,orders,lineitem,supplier,nation,region
  SELECT
    n_name,
    sum(l_extendedprice * (1 - l_discount)) AS revenue
  FROM
    customer,
    orders,
    lineitem,
    supplier,
    nation,
    region
  WHERE
    c_custkey = o_custkey
    AND l_orderkey = o_orderkey
    AND l_suppkey = s_suppkey
    AND c_nationkey = s_nationkey
    AND s_nationkey = n_nationkey
    AND n_regionkey = r_regionkey
    AND r_name = 'ASIA'
    AND o_orderdate >= DATE '1994-01-01'
    AND o_orderdate < DATE '1994-01-01' + INTERVAL '1' YEAR
  GROUP BY
  n_name
  ORDER BY
  revenue DESC
  