Spark SQL questions

E. (15 pts] Spark SQL Questions A DataFrame called Employee has five columns namely, ID, Fname, Lname, Salary, DeptNo. Assume the DataFrame is already created. Write the following Spark SQL statement that shows, a. [5 pts) The average salary of each department (DeptNo). b. [5 pts) ID and Fname of an employee with the highest salary. c. [5 pts) Write any ranking function using the above-mentioned Employee DataFrame