Sobes.tech
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)