How to sort by three fields as expected?

Question

SQL

Greetings.

The table has three fields:

1. score-int
   
2. distance-int
   
3. peoples-int
   

I need to display a record that has:

1. Highest score
   
2. smallest distance
   
3. largest peoples
   

Concocted a request:

SELECT * FROM Table ORDER BY score DESC, distance ASC, peoples DESC

I expect that the result will be entries at the beginning that best fit all the criteria at once. But in fact, the priority, which depends on the order of the fields, affects so much that the bias in one parameter is too large. It would be desirable something like "natural sorting" on three fields.

Answer 1

formulate a criterion that matches your expectations and sort by its value

Answer 2

I don't know, of course, but maybe it will work?

SELECT * FROM Table where max(score) and min(distance) and max(peoples);

Answer 3

You can try sorting in excel)
In general, order by with a list of sorting criteria sounds exactly like sorting first by the first criterion inside the same - by the second and so on ...
And what you want - it suggests itself as the first criterion - something synthetic from all three criteria. For example, if these metrics are represented as coordinate axes, then the distance from the origin can be used as a synthetic metric - that is, the square root of the sum of squares (in this case, the root can be excluded for ordering).