Re: left join on same table use different "where" clause

[Peter Brawley]

Is this what you mean?

select contractor,n as jobs,completed,round(100*completed/n,2) as Pct
from (
  select contractor,sum(if(status='completed',1,0) as completed,count(*) as n
  from tbl
  where year(reportdate)=2012
  group by contractor;
) x;