Is there a name for this kind of SQL programming style?
--Courtesy of Markus Winand of modern-sql.com/ SELECT * FROM (SELECT cities.* , ROW_NUMBER() OVER(PARTITION BY country ORDER BY population DESC) rn , COUNT(*) OVER(PARTITION BY country) ct_cities FROM cities ) t WHERE t.rn = 1 AND t.ct_cities > 1
Source: db<>fiddle related to this topic: Oracle Idea: FIRST() and LAST() aggregate functions
It's as if there is a line between the SQL keywords (right-justified) and the criteria (left-justified).
Whereas in other SQL styles, the SQL keywords are left-justified.
I ask because that style seems easy to read and I want to find out more about it.
Edit; a related post: SQL Developer - Keep analytic function on single line when auto-formatting