treehouse : what would you like to learn today?
Web Design Web Development iOS Development

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

  • 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