  select sum(lo_revenue), d_year, p_brand1
    from lineorder, "date", part, supplier
   where lo_orderdate = d_datekey
     and lo_partkey = p_partkey
     and lo_suppkey = s_suppkey
     and p_brand1 between 'MFGR#2221' and 'MFGR#2228'
     and s_region = 'ASIA'
group by d_year, p_brand1
order by d_year, p_brand1;
