Firebird - Common Table Expressions (CTE)

WITH Tab_Cidades_RS AS (
  SELECT C.*
  FROM Cidade C
  WHERE
  C.UF='RS'
)

SELECT * FROM Tab_Cidades_RS
WHERE
DescCidade starts WITH 'F'