ขอคำแนะนำหน่อยครับ ควรจะเขียนลูปยังไง มีตัวอย่างครับ

select my_type,sum(score) as score from (
select tdate,type1 as my_type,t1 as score from test_tbl
UNION ALL
select tdate,type2 as my_type,t2 as score from test_tbl
) as t 
where tdate='01/02/2018'
group by my_type

select type1, sum(t1) from(
select type1, t1 from tbname 
union all
select type2, t2 from tbname
) a group by type1