SELECT ROW_NUMBER() OVER (frame) rn,
       COUNT(*) OVER (frame) cnt
...
WINDOW frame (... ORDER BY ...)

mysql> WITH RECURSIVE cte AS (
    -> SELECT 1 num
    -> UNION ALL
    -> SELECT 3
    -> UNION ALL
    -> SELECT num+1 FROM cte WHERE num < 5
    -> )
    -> SELECT num, COUNT(*) OVER (frame) cnt, COUNT(*) OVER (ORDER BY num DESC) cnt_d, ROW_NUMBER() OVER (frame) rn
    -> FROM cte
    -> WINDOW frame AS (ORDER BY num DESC);
+------+-----+-------+----+
| num  | cnt | cnt_d | rn |
+------+-----+-------+----+
|    5 |   8 |     2 |  1 |
|    5 |   8 |     2 |  2 |
|    4 |   8 |     4 |  3 |
|    4 |   8 |     4 |  4 |
|    3 |   8 |     6 |  5 |
|    3 |   8 |     6 |  6 |
|    2 |   8 |     7 |  7 |
|    1 |   8 |     8 |  8 |
+------+-----+-------+----+
8 rows in set (0.01 sec)