g Write and run SQL queries to retrieve the information requested. Take screenshots
g Write and run SQL queries to retrieve the information requested. Take screenshots of the queries and the results. 1)Display the names of all students whose last name is Smith. 2)Display the names of all students whose last name begins with R. 3)Display the total of all salaries in the SWENG department. Also display the total for the department if all department members are given a 3% raise in salary. 4)Display the name of the faculty member with the highest salary. 5)Display the name of the faculty member in the CMPSC department with the lowest salary. 6)Display the names of all students whose major is in the same department to which faculty member Sanjay Gupta belongs. Use a join. 7)Display the names of all students whose major is in the same department to which faculty member Sanjay Gupta belongs. Use a subquery. 8)Display the name, department, and salary of all faculty members, regardless of department, whose salary is less than the average salary of faculty in the SWENG department. 9)Display the name, department, and salary of all faculty members, regardless of department, whose salary is greater than the salary of every faculty in the CMPSC department. 10)Display the student id and student name of the student(s) advised by the faculty member in CMPSC who has the highest salary.