The hierarchy of SQL expression

• scalar expr, a single value know as a field, or a list of single value know as a row
  • primary expr, in a primitive form.
    • value expr, a constant specifies a value.
      • literal
    • function call
  • binary expr, a combination of the other 2 expressions.
• query expr(table expr), a set of rows