Nissan elgrand tailgate awningrelational algebra to express each of the following queries: a. Find the names of all employees who live in city “Miami”. b. Find the names of all employees whose salary is greater than $100,000. c. Find the names of all employees who live in “Miami” and whose salary is greater than $100,000. Answer: a. 5 name (s city=“Miami ... Turska serija yemin sa prevodomWrite an SQL query to print the name of employees having the highest salary in each department. Could you please help me to get the highest salary for each department. If multiple employees having the highest salary in the same department then I need the get oldest employee details(who joined first in the company).