Database Systems
SWE · Quiz · Summer 26
Paper 1 of 5Section C · Batch 45Switch
Section C · Batch 45
Paper 1 of 5
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
Daffodil International University
Department of Software Engineering
Quiz 2, Summer 2026, Section: 45 C
Course Code: SE223; Course Title: Database System
Marks - 15
35 min
Student
student_id | student_name | gender | city | cgpa | dept_id
Department
dept_id | dept_name | building | budget
Enrollment
student_id | course_name | semester | marks
Following above write MYSQL Queries for the Followings (15 marks)
1. Display the names and CGPA of all students whose CGPA is below 3.5
2. Display the students whose CGPA is greater than 3.50 in spring 2026 in OOP
3. Display the names of students who live in Dhaka or Chattogram (without using Logical Operator)
4. Display all unique department IDs from the Student table.
5. Display the names of students whose names end with the letter 'NA'.
6. Display all students ordered by CGPA in descending order.
7. Display the average CGPA of all students for each department
8. Display the names of departments whose budget is greater than some of the department budgets located in the Academic Building.
9. Display the department IDs where their average CGPA is in between 3.00-3.00
10. Display the student name and department name located in Knowledge Tower
11. Display the student name, course name, and marks obtained by each student.
12. Display the names of students whose CGPA is greater than the average CGPA of all students.
13. Display the names of students who are not enrolled in any course. (RIGHT JOIN)
14. Display the names of departments whose budget is greater than ALL department budgets of departments located in the Academic Building. (Subquery)
15. Display the names of students who are enrolled in "Database Systems" and whose marks are greater than the average marks obtained in that course. (Subquery)