I have searched on the forums and failed to find how can one name columns for a values statement subquery.

Here is my query in MySQL:

SELECT *
FROM (VALUES
    ('PPA', 'blah', 30)
    , ('PPB', 'blah blah', 60)
) AS X

Here is what I can do in T-SQL:

SELECT x.a, x.b, x.c
FROM (VALUES
    ('PPA', 'blah', 30)
    , ('PPB', 'blah blah', 60)
) AS x(a, b, a)

Very simple, yet can’t find out.