mysql queries

Performing a sort on a table for a scoring system The first criterion is 1 choice field. We first sort users with choice 1 then users with choice 0 Then sort the users according to the result and assign 1 point to the first 2 points to the second; 3 points to the third For equalities the same number of points at all. Each event can contain several matches It is necessary to be able to display the result by match and the general result by event (total points of each match) There will additionally be selection filters which must be combined and / or By age group By sex By weight By size There are 4 tables Users logs Event Match