SQL

sql with as

WITH temporaryTable (averageValue) as
    (SELECT avg(Attr1)
    FROM Table)
    SELECT Attr1
    FROM Table, temporaryTable
    WHERE Table.Attr1 > temporaryTable.averageValue;

SQL AS With Expression

SELECT CONCAT(first_name, ' ', last_name) AS full_name
FROM Customers;