Write down the Query for the following table? StudentID StudentName Age Department 1 Alice 20 CSE 2 Bob 22 EEE 3 Charlie 21 CSE 4 David 23 BBA (i)…
Write down the Query for the following table?
| StudentID | StudentName | Age | Department |
| 1 | Alice | 20 | CSE |
| 2 | Bob | 22 | EEE |
| 3 | Charlie | 21 | CSE |
| 4 | David | 23 | BBA |
(i) Shows only students in the CSE department.
(ii) Shows all students sorted by age (highest first).
(iii) Shows how many students are in each department.
From the DESCO Sub-Assistant Engineer (CSE) June 2025 – Written (BUET) exam, question 9 of 9.