/* 009- Alias , AS */ -- syntax -- SELECT ID AS CustomerID FROM table_name; make it more readable -- SELECT CustomerID ID FROM Customers; AS keyword optional -- SELECT column_name AS alias_column_name FROM table_name; alias for column -- SELECT column_name(s) FROM table_name AS alias_table_name; alias for table -- create column CREATE TABLE tOne( id INT, name VARCHAR(50), age INT , gender VARCHAR(1), phone VARCHAR(10), city VARCHAR(15) ); -- enter the data INSERT INTO tOne(id,name,age,gender,phone,city) VALUES (1,"Ram Kumar","23","M","4022155","Agra"), (2,"Sarita Kumari","21","F","4034421","Delhi"), (3,"Salman Khan","20","M","4056221","Agra"), (4,"Juhi Chawla","28","F","4022156","Bhopal"), (5,"Anil Kapoor","22","M","4025221","Agra"), (6,"John Abraham","21","M","4056776","Delhi"); -- for making it more readible SELECT id AS Id,name AS Student,phone AS Phone FROM tOne WHERE city = "Agra"; SELECT id AS Id,name AS "Student Name" FROM tOne WHERE city = "Agra"; --if two word ,then use double quotes