See the below tables and solve the given queries.

Table: Employee

 

 

Table: Incentives

 

 

Questions

1. Get all employee details from the employee table.
2. Get First_Name, Last_Name from employee table.
3. Get First_Name from employee table using alias name “Employee Name”.
4. Get all employee details from the employee table order by First_Name Ascending.
5. Get all employee details from the employee table order by First_Name Descending.
6. Get all employee details from the employee table order by First_Name Ascending and Salary Descending.
7. Get employee details from employee table whose employee name is “John”.
8. Get employee details from employee table whose employee name are “John” and “Roy”.
9. Get employee details from employee table whose employee name are not “John” and “Roy”.
10. Get employee details from employee table whose first name starts with 'J'.
11. Get employee details from employee table whose first name contains 'o'.
12. Get employee details from employee table whose first name ends with 'n'.
13. Get employee details from employee table whose first name ends with 'n' and name contains 4 letters.
14. Get employee details from employee table whose first name starts with 'J' and name contains 4 letters.
15. Get employee details from employee table who’s Salary greater than 600000.
16. Get employee details from employee table who’s Salary less than 800000.
17. Get employee details from employee table who’s Salary between 500000 and 800000.
18. Get employee details from employee table whose name is 'John' and 'Michael'.
19. Get employee details from employee table whose joining month is “January”.
20. Get employee details from employee table who joined before January 1st 2013.
21. Get employee details from employee table who joined after January 31st .

Note:

1. Upload screenshots containing query and its output in either jpg or png format.
2. Name of screenshot file name must be Question No. i.e. 1.jpg or 1.png.
3. Optional questions are not required to submit.