select c_city,s_city,d_year,sum(lo_revenue) as revenue
from lineorder,customer,supplier,ddate
where lo_custkey = c_custkey
and lo_suppkey = s_suppkey
and lo_orderdate = d_datekey
and c_nation = 24
and s_nation = 24
and d_year >=1992 and d_year <= 1997
group by c_city,s_city,d_year;