Company: Amazon Senior business research scientist_14april
Difficulty: medium
Problem Description In the Amazon Student Internship Program, students are required to complete various training modules. Some students may have "backlogs" (incomplete modules) recorded in the system. Write a SQL query to retrieve a list of the names of all students who have at least one backlog item recorded in the backlog table. Schema The database contains the following two tables: student Column Type Description ID INTEGER The unique identifier for the student (Primary Key). NAME VARCHAR The name of the student. backlog Column Type Description STUDENT_ID INTEGER The ID of the student (Foreign Key referencing student.ID ). SUBJECT_ID VARCHAR The unique identifier for the training module/subject. Required Output The result should contain a single column: NAME : The name of the student. Constraints or Notes The results must be sorted in alphabetical order by the student's name. Each student should appear only once in the output, even if they have multiple backlog items. Only students