SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

 CREATE TABLE table1(var1 INTEGER);
CREATE TABLE table2(var2 INTEGER);
 INSERT INTO table1 VALUES (1),(2),(3);
INSERT INTO table2 values (4),(5),(6);
CREATE VIEW my_view(result, place) AS
 SELECT result, row_number() OVER (ORDER BY result DESC)
 FROM (SELECT (var1 * 2 - var2 * 3) AS result
       FROM table1
       JOIN table2)
 ORDER BY result DESC;
SELECT * FROM my_view;


result
place


-6
1

-8
2

-9
3

-10
4

-11
5

-12
6

-13
7

-14
8

-16
9