Question 2 (1)
Active backlogs There is a database with two tables:students and backlog. Each student has a unique ID. There is a backlog table that maintains a record of active backlogs for each student.
Task
Write a query to print the name of the students who have at least one active backlog. The names should be printed I in ascending order.The result should I be in the following format: NAME
Table description
Table: student
Name I Type Description LID LINTEGER This is the student’s ID. It is the primary key. INAME I STRING ll This is the name of the student.
Table: backlog
Name Type Description I STUDENT_ID INTEGER This is the student’s ID. II SUBJECT ID I STRING | This is the subject ID.
Example
student
$\square $ $\square $ $\square $ $\square $ I Chris $\square $ $\square $ Sam I Sam $\square $ Ale $\square $ disappointed
backlog
| STUDENT_ID I SUBJEC T_ID $\square $ $\square $ $\square $ disappointed $\square $
Output
Note:
Your SQL query must be able to print the sample output from the provided sample input . However, the query is run against multiple hidden test cases . Therefore, your query must pass these hidden test cases to solve the problem statement.
Time Limit: 5 sec(s)for each input file
Memory Limit: 256 MB Source Limit: 1024 KB
Score is assigned if any testcase passes Allowed Languages
MySQL, PostgreSQI , MSSQL, Oracle Db