Hows about
SELECT date_format( regdate, '%M %Y' ) month,
sum( state = 'good' ) good,
sum( state = 'bad' ) bad,
sum( state = 'very bad' ) very_bad
FROM `cars`
WHERE car = 'toyota'
GROUP BY MONTH