Q:Question:Write a SQL statement to show Name, Department and City. f. Write a SQL statement to show Name, Department, Salary and their Rank WITHIN Department from highest to lowest salary. i.e., Salary rank must reset and re-rank start from 1 for EACH Department. d. Write a SQL statement to find distinct employee Name who is also a manager. g. Write a SQL statement to find HIGHEST paying employee's Name and Salary from the entire a. Write a SQL statementA:Answer:See a step by step answer