combining two rows wit the Query Builder

Thanks Beer. I ended up merging the rows with this statement.
$sql="INSERT INTO substantially_all_render_temp2 SELECT '',PR, taxyear,
sum(research_dol) as research,
sum(support_dol) as support,
sum(supervision_dol) as supervision,
sum(research_dol) as total_POE_dol,
sum(research_dol)+sum(support_dol)+sum(supervision_dol) as total_BC_wages_dol,
sum(research_dol)*100/ (sum(research_dol)+sum(support_dol)+sum(supervision_dol)) as percent_substantially_all
FROM substantially_all_render_temp
GROUP BY BC, taxyear";

proof that an old dog can learn new tricks