mysql – select users with max(field) and min(field)

[amis]

I have table (results) with theses fields
result_id
username
true
false

i want select users which have max(true) and min(false)

for example , if 2 users have the following
x-> true(20) , false(10)
y – > true(15) , false(2)

i want choose the y first as it’s percentage is high

i mean making percentage between true , false

[Author]

Posts