resources/ssb/3.1.sql

0001 select c_nation, s_nation, d_year, sum(lo_revenue) as revenue
0002         from customer, lineorder, supplier, date
0003         where lo_custkey = c_custkey
0004                 and lo_suppkey = s_suppkey
0005                 and lo_orderdate = d_datekey
0006                 and c_region = 'ASIA'
0007                 and s_region = 'ASIA'
0008                 and d_year >= 1992 and d_year <= 1997
0009         group by c_nation, s_nation, d_year
0010         order by d_year asc, revenue desc