https://starslayerx.github.io/posts/sql-lexical-order-and-syntax-order/
SQL Lexical Order and Syntax Order