Given Student(sid, name, dept) and Course(sid, cid, cname, marks), Find the student name, department, course name, and marks where marks are greater…

Given Student(sid, name, dept) and Course(sid, cid, cname, marks), Find the student name, department, course name, and marks where marks are greater than 80.

Find department-wise and subject-wise students where marks are not less than 30.

From the ICB Assistant Programmer June 2026 – Written exam, question 2 of 11.

More from this paper