How would you write a single SQL statement to get the output as: Col1 val x 1 y 2 z 3 (Note; Hardcoding not allowed.)

WITH cte(col1)      AS (SELECT 'x'          UNION          SELECT 'y'          UNION          SELECT 'z') SELECT col1,        Row_number()          OVER(            ORDER BY col1) AS val FROM   cte 

HTH