SELECT ROW_NUMBER() OVER(PARTITION BY a.object_id ORDER BY a.object_id)
FROM sys.objects a
CROSS JOIN sys.objects b
CROSS JOIN sys.objects c

PS > sqlfluff fix --config .\.sqlfluff .\query.sql
==== finding fixable violations ====
== [query.sql] FAIL
L:   3 | P:  24 | L025 | Alias 'b' is never used in SELECT statement.
L:   4 | P:  24 | L025 | Alias 'c' is never used in SELECT statement.

Msg 1013, Level 16, State 1, Line 1
The objects "sys.objects" and "sys.objects" in the FROM clause have the same exposed names. Use correlation names to distinguish them.

SELECT ROW_NUMBER() OVER(PARTITION BY a.object_id ORDER BY a.object_id)
FROM sys.objects a
CROSS JOIN sys.objects b
CROSS JOIN sys.objects c