/*alias table*/
-- SQL aliases are used to give a table, or a column in a table, a temporary name..
-- An alias is created with the AS keyword.
create table employee(EmpID int, EmpFirstName varchar(255),EmpLastName varchar(255),Address varchar(255),salary int);
insert into employee(EmpID, EmpFirstName, EmpLastName, Address, Salary)
values(1,"John","Doe","Delhi",10000),
(2,"Collins","john","Chandigarh",20000),
(3,"Johny","Doey","Delhi",10000),
(4,"Collinsy","johny","Chandigarh",20000),
(5,"Harryy","Jonesy","Delhi",15000); 

select EmpFirstName as "Employee First Name",EmpLastName as last from employee;
select * from employee;