Write a SQL query using a LEFT JOIN to identify records in a Students table that do not have corresponding entries in a Marks table.
Return each student without any marks record, including students whose IDs do not appear in Marks.
student_id, student_namestudent_id in ascending order| Column | Type | Description |
|---|---|---|
| student_idPK | INT | Unique identifier for the student |
| student_name | VARCHAR(100) | Student's full name |
| grade_level | INT | Student's grade level |
| Column | Type | Description |
|---|---|---|
| mark_idPK | INT | Unique identifier for the marks record |
| student_id | INT | Student associated with the marks record |
| subject | VARCHAR(50) | Subject for the recorded mark |
| score | NUMERIC(5,2) | Numerical score for the subject |