Inspection Percentage Completion

select sum(a.selesai_lp ) as selesai_lp, sum(a.harta_keseluruhan) as harta_keseluruhan,
round(sum(a.selesai_lp )/sum(a.harta_keseluruhan)*100,2) as peratus_selesai_lp
from (
select 0 as harta_keseluruhan, count(*) as selesai_lp from t_harta_status ths
where ths.id_status_harta >= 6
union
select count(*) as harta_keseluruhan, 0 selesai_lp from stg_ntharta sn
) a;