|
||||
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_yearmonth = 'Dec1997' 0011 group by c_city, s_city, d_year 0012 order by d_year asc, revenue desc
[ Source navigation ] | [ Diff markup ] | [ Identifier search ] | [ general search ] |
This page was automatically generated by the 2.1.0 LXR engine. The LXR team |