Re: I need help with structuring a table

[Bob Field]

SELECT date,
sum( if( status = 'pass',   count_status, 0)) AS Pass,
sum( if( status = 'fail',   count_status, 0)) AS Fail,
sum( if( status = 'killed', count_status, 0)) AS Killed
FROM yourTable
GROUP BY date;