Page 1 of 1
There is a database containing the marks of some students in various subjects. The data may contain any number of subjec
Posted: Fri Jul 01, 2022 5:51 am
by answerhappygod
- 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 94 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