1- Write a query to display the names (first_name, last_name) from employees table using alias name First Name", "Last Name"

2- Write a query to display the names (first_name concatenate last_name) from employees table using alias name Employee Name"

3- Write a query to get unique department ID from employee table

4- Write a query to get all employee details from the employee table

5- Write a query to get the employee ID, first_name, last_name, salary for employees who make more than 15000

6- Write a query to get the employee ID, first_name, last_name, department ID for the employees who don't work in department ID 80

7- Write a query to get all data from the jobs table

8- Write a query to get the employee ID, first_name, last_name, salary for employees who make 6000 and less

**********

9- Write a query to display the first name and hire date of the employees who joined between 2001 and 2007, order by the hire date.

10- Write a query to display first name and hire date of the employees whom job id either ST_CLERK or IT_PROG.

11- Write a query to display first name, last name of employees who joined after 1st January 2005.

12- Write a query to display all details of employee with ID 180 or 120.

13- Write a query to display all details of jobs in the descending order of the job title.

14- Write a query to display employees where the first name or last name starts with J.

15- Write a query to display first name, last name,hire date of employees who joined in the month of January of any year.

16- Write a query to display first name and last name after converting the first letter of each name to upper case and the rest to lower case.

17- Write a query to display first name, last name of employees who joined in the current year (use sysdate) ordered by first name.

18- Insert a new employee into employees with all the required details.

19- Delete department id 20.

20- Change job ID of employee 110 to IT_PROG if the employee belongs to department 10 and the existing job ID does not start with IT.