SQLite how to sort by multiple columns at once?

Question

SQLite

There is a table:
name | v1 | v2 | v3
----------------------
Vova | 2 | 0 | 0
Vanya | 0 | 0 | 0
Grisha| 0 | 4 | 0
Vasya | 0 | 0 | 10
Petya | 1 | 20 | 40

The task is to display the names by sorting by columns v1 v2 v3, and take into account when sorting sequentially the fields starting from v1 with the condition that the field is greater than zero.
Result: Vasya (10), Grisha (4), Vova (2), Petya (1), Vanya (0)

Answer 1

In this case you can use case statement with where statement

select * from users
order by case 
  when v1 > 0 then v1 
  when v2 > 0 then v2
  else v3
end desc;

SQLite online sandbox