New posts in Table Alias

SQL Command not properly ended?

Is there a way to give a subquery an alias in Oracle 11g SQL?