Select Columns

SELECT columns

Columns

    SELECT size
    SELECT City.Name, City.Population

Expressions

    SELECT LCASE(City), 2+2

Aggregators

    SELECT COUNT(*), SUM(Population)

Alias

    SELECT City+” “+Country AS LongName