CODE EXAMPLE FOR SQL

sql as multiple columns

select column_name as alias, column_name2 as alias2 from tablename;

#You can also give the same column different alias 
select author as forwards-name, author as backwards-name from books;