Concatenation and alias

SQL aliases(as): are used to give a table, or a column in a table, a temporary name.Aliases are often used to make column names more readable

concatenation(||): means to combine two or more columns.For example we can combine column of first name and last name.

Syntax:

SELECT column_name1 | | column_name2  AS  “alias_name” FROM table_name;