I rarely had the chance to write RAW SQL query, I wrote this query but feel like something is not right about it. I wonder if there is a better way to write it. Maybe I will learn something new.
select a.approved, c.review, d.pending, f.total, f.total - a.approved - c.review as ongoing
from
(select count(distinct sownumber) as approved from v_scope_of_work_combined where name = 'CTN-Approve' and assigned_engineer_my_tasks = 'NotClaimed' and sow_status = 'PM Approved' and implementer = 'C1') as a,
(select count(distinct sownumber) as review from v_scope_of_work_combined where name = 'CTN-Approve' and assigned_engineer_my_tasks != 'NotClaimed'and sow_status = 'PM Approved' and implementer = 'C1') as c,
(select count(distinct sownumber) as pending from v_scope_of_work_combined where name = 'CTN-Approve' and v_scope_of_work_combined.design_readiness = 'No'and sow_status = 'PM Approved' and implementer = 'C1') as d,
(select count(distinct sownumber) as total from v_scope_of_work_combined where sow_status = 'PM Approved' and implementer = 'C1') as f;
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…