Consider the following two relations, write sql queries for the following.

Employee$($EmployeeID$,$ FirstName, LastName, DepartmentID, and Salary$)$

Deparment$($DepartmentID$,$ DepartmentName$)$

Write an insert query to insert the following employee $-$ John Brown with an employee id of $101$ a department id of S$101$ and

Salary of $$80,000$

Retrieve the FirstName, LastName, and Salary of employees who work in the 'Sales'$($DepartmentName$)$ and have a salary

greater than $$50,000$

Retrieve the FirstName, LastName, and Salary of employees who have a salary greater than the average salary of all

employees