The hierarchy of SQL expression

1.scalar expr

1.1 primary expr

1.1.1 function call

1.1.2 value expr

1.1.2.1 literal

1.2 binary expr

2.query expr(table expr)