Just need my worked checked

SQL Mastery Assignment

Let us consider a table named Employee. We are going to use this table to write different SQL Queries.

Query 1: List the employee whose employee number is 100.

Query 2: List the Employee whose salary is between 50 K to 100 K.

Query 3: List the Employees whose name starts with ‘Ami’.

Query 4: List the Employees whose name starts with A and surname starts with S.

Query 5: List the Employees who’s surname contains kar word.

Query 6: List the Employees whose name starts with P,B,R characters.

Query 7: List the Employees whose name does not start with P,B,R characters.

Query 8: Write a query to fetch the first record from the Employee table.

Query 9: Write a query to fetch the last record from the Employees table.

Query 10: Write a query to find the 2nd highest salary of Employees using Self join.

Query 11: Write a query to display odd rows from the Employees table.

Query 12: Write a query to display even rows from the Employees table.

Query 13: Write a query to show the max salary and min salary together from Employees

table.

Query 14: Write a query to fetch all the records from Employee whose joining year is 2018.

Query 15: Write a SQL Query to find maximum salary of each department.

Query 16: Write a query to find all Employees and their managers? (Consider there is

manager id also in Employee table).

Query 17: Write a query to display 3 to 7 records from Employee table.

Query 18: Write a query to fetch common records from two different tables Employees and

Employees1 which has not any joining condition.

Query 19: Write a query to validate Email of Employee.

Query 20: Write a query to remove duplicate rows from Employees table.