Course- database administration

subject- relational database

1- Find the first name, last name of employees who are earning 9000

2- Select all employees whose hire date is between the dates '03-06-17' AND '06-01-03';

3- Display a list of employees whose first name contains the characters 'an'.

4- Display the list of employees whose last name has 5 characters

5- Display the list of employees whose the second letter of the last name is a;

6- Write a query to list the first name, last name, and salary for the first 10 employees contained in the employee's table.

7- Write a query to list the employee's name and total salary of a year and yearly salary is more than $10000.

8- Write a query to list the name of all the employees who are not working in department number 20. 9- Write a query to list the name, and salary of all the employees where the employee's first name belongs in a specified list. (Steven, Lex)

10- Display the list of all the cities that have a province Ordered by country id