We have a table called students that contains the last name,…
We have a table called students that contains the last name, first name, middle initial, student id, and grade they received in each course. Here is a sample of three students: Construct a SQL query that will return two columns full name (example: “John A. Smith”) average grade for all courses (all rows) rounded to the nearest whole number (example student 101 averaged a grade of 88.0) Some notes: id is the only column unique to the student. You can assume all students have middle initials.SELECT _______ AS full_name, _______ AS grade_avgFROM students _______ _______ ;