Intern — Middle
Display all students with their grades
livecode
Task condition
Write an SQL query that outputs a list of all students along with their grades (student name, subject, grade). If a student has no grades, they should still appear in the result, with the subject and grade fields being NULL.
The database contains two tables:
Students(id, name)
Grades(student_id, subject, grade)