I have a table with the following fields;
player_id = int
fixture_id = int
up_vote = bool
I'm trying to come up with a query where I can return the % of results where the up_vote is equal to 1
so if there are 100 rows for fixture_id 78, and the value of up_vote in 75 of those rows in 1, then the result would be 75%.
I don't really know where to start with this one without performing multiple queries which I'm trying to avoid if I can.