I have a table and it has information about training taken:
Joe Blow Training 1 Pass
Joe Blow Training 2 Fail
Joe Blow Training 3 Pass
Jane Doe Training 2 Pass
Jane Doe Training 3 Fail
From that data, I want to create a table that just has percentages like:
Joe Blow Passed 66% Failed 33%
Jane Doe Passed 50% Failed 50%
Is there a way to do that from a second query against the first query?
I prefer a SQL query over a stored procedure if possible.