0001 select c_city, s_city, 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_nation = 'UNITED KINGDOM'
0007 and (c_city='UNITED KI1' or c_city='UNITED KI5')
0008 and (s_city='UNITED KI1' or s_city='UNITED KI5')
0009 and s_nation = 'UNITED KINGDOM'
0010 and d_year >= 1992 and d_year <= 1997
0011 group by c_city, s_city, d_year
0012 order by d_year asc, revenue desc