status" must appear in the GROUP BY clause or be used in an aggregate function

trying to get success and failed status count in same line instead getting 2 records for...