framework/resources/Functional/subqueries/with_clause/drill-2318-1.sql

WITH
     x
     AS (SELECT  
                a1
         FROM  
                t1)
SELECT  x.a1    
FROM    x
ORDER  BY 
        x.a1;