Question$7$ LEFT JOINsIdentify the correct data that is returned from a LEFT JOIN between two tables.Use the following data model for this question:Student table student$\_$id student$\_$nameAssignment$\_$Grade table assignment$\_$id student$\_$id gradeWhat data will you get by running the following query?SELECT student$\_$name, grade, FROM StudentLEFT JOIN Assignment$\_$Grade ON student$\_$idWHERE assignment$\_$id $=5$;A$.)$A list of all students and their grades on all assignments, excluding students who have no grades for Assignment $5$B$.)$A list of all assignments and all students, but NULL values are entered for any students with no grades or grades with no studentsC.$)$A list of all students and their grades on Assignment $5,$ but any students who have no grade for this assignment will appear in the list with a NULL gradeD.$)$A list of all students who have completed Assignment $5$ and their grades on it