Answer Happy

Posted: **Fri Jul 01, 2022 5:52 am**

: There Is A Database Containing The Marks Of Some Students In Various Subjects The Data May Contain Any Number Of Subjec 1 (118.94 KiB) Viewed 111 times

: There Is A Database Containing The Marks Of Some Students In Various Subjects The Data May Contain Any Number Of Subjec 2 (66.89 KiB) Viewed 111 times

There is a database containing the marks of some students in various subjects. The data may contain any number of subjects for a student. Retrieve the records of students who have a sum of marks greater than or equal to 500. The result should be in the following format: STUDENT_ID SUM OF MARKS sorted descending by STUDENT ID. ▼ Schema There is 1 table: marks. Name Type Description STUDENT_ID INTEGER This is the student's unique ID. INTEGER These are the marks obtained. MARKS Sample Data Table STUDENT_ID MARKS 1 marks 2 450 marks 200
Sample Data Tables student ID NAME 1 Chris 2 3 Sam Alex STUDENT_ID SUBJECT_ID 1 backlog 3 Sample Output Alex Chris abc123 def456 Explanation Fach of the students listed has at least one record in the backlog table.