 )  select table0.status,count(table0.id) from table0,table0 where table0.statusid=table0.statusid group by table0.statusid  union select 'No status Id',count(table0.id) from table0 where table0.statusid