Q-1. Write an SQL query to fetch FIRST_NAME from Worker table using the alias name as .

Q-2. Write an SQL query to fetch FIRST_NAME from Worker table in upper case.

Q-10. Write an SQL query to print the FIRST_NAME and LAST_NAME from Worker table into a single column COMPLETE_NAME.

A space char should separate them.

create table if not exists worker( worker_id int not null auto_increment, first_name varchar(25) not null, LAST_NAME varCHAR(25) not null, SALARY INT (15), JOINING_DATE DATETIME, DEPARTMENT varCHAR(25) not null, primary key(worker_id)

);

INSERT INTO Worker(WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE,DEPARTMENT) VALUES(001, 'Monika', 'Arora', 100000, '2014-02-20 09:00:00', 'HR'), (002, 'Niharika', 'Verma', 80000, '2014-06-11 09:00:00', 'Admin'), (003, 'vishal','Singhal', 300000, '2014-02-20 09:00:00', 'HR'), (004, 'Amitabh', 'Singh', 500000, '2014-02-20 09:00:00', 'Admin'), (005, 'Vivek', 'Bhati', 500000, '2014-06-11 09:00:00', 'Admin'), (006,'vipul','diwan',200000,'2014-06-11 09.00.00','Account'), (007,'satish','kumar',75000,'2014-01-20 09.00.00','account'), (008,'geetika','chauhan',90000,'2014-04-11 09.00.00','admin');