Skip to content

Database Systems

SWE · Quiz · Summer 26

Paper 1 of 5Section C · Batch 45Switch

Section C · Batch 45

Paper 1 of 5

This browser can’t show the PDF here

Open it, and your phone’s PDF viewer takes it, or download it.

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)