select sum(lo_revenue),d_year,p_brand1
from lineorder,part,supplier,ddate
where lo_orderdate = d_datekey
and lo_partkey = p_partkey
and lo_suppkey = s_suppkey
and p_brand1 = 260
and s_region = 3
group by d_year,p_brand1;