There is a database containing the marks of some students in various subjects. The data may contain any number of subjec

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

There is a database containing the marks of some students in various subjects. The data may contain any number of subjec

Post by answerhappygod »

There Is A Database Containing The Marks Of Some Students In Various Subjects The Data May Contain Any Number Of Subjec 1
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 93 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”