One use case for an alias is a query that joins a table to itself, known as a$($n$)q,$

inner join

outer join

union

self$-$join