Microsoft - Microsoft SQL Server - SQL - Sub Queries

SELECT column1, column2 FROM 
(SELECT column_x  AS C1, column_y FROM TABLE WHERE PREDICATE_X)
AS table2
WHERE PREDICATE;