text: -- tpch5 using 1395599672 as a seed to the RNG
  select
    n.n_name,
    sum(l.l_extendedprice * (1 - l.l_discount)) as revenue
  
  from
    customer c,
    orders o,
    lineitem l,
    supplier s,
    nation n,
    region r
  
  where
    c.c_custkey = o.o_custkey
    and l.l_orderkey = o.o_orderkey
    and l.l_suppkey = s.s_suppkey
    and c.c_nationkey = s.s_nationkey
    and s.s_nationkey = n.n_nationkey
    and n.n_regionkey = r.r_regionkey
    and r.r_name = 'EUROPE'
    and o.o_orderdate >= date '1997-01-01'
    and o.o_orderdate < date '1997-01-01' + interval '1' year
  group by
    n.n_name
  
  order by
    revenue desc
  