SQL

SQL multiple column

ALTER TABLE Colleges
ADD UNIQUE UniqueCollege (college_id, college_code);

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;

How to select multiple columns in SQL

-- You can select data from a table using a SELECT statement.
-- Select multiple columns from table:
SELECT example_column, example_column2
FROM example_table;