This is valid? or I must create a stored procedure just to return the
subselect? (this is just example, not my real problem).

SELECT NAME FROM (SELECT * FROM CUSTOMER) ORDER BY NAME DESC