Problem mit Alias bei einfacher Abfrage

[SQL]

gas.typ = "Gas" ist nicht korrekt:

A string constant is formed by enclosing the string in single quotes ('). A single quote within the string can be encoded by putting two single quotes in a row - as in Pascal. C-style escapes using the backslash character are not supported because they are not standard SQL.

https://www.sqlite.org/lang_expr.html