List all the results from the musicals.
select result from musical
How many are there for each result type?
select result, count(*) from musical group by result
Which one is the most popular result?
select result from musical group by result order by count(*) desc limit 1