Given a Patient table in a hospital database below. Patient Patient_ID Disease_Name 1 Covid-19 2 Dialysis 3 Covid-19 4 Dengue Write down an SQL…
Given a Patient table in a hospital database below.
Patient
| Patient_ID | Disease_Name |
| 1 | Covid-19 |
| 2 | Dialysis |
| 3 | Covid-19 |
| 4 | Dengue |
Write down an SQL query to display the total number of patients under each disease category.
From the BPSC Network/Website Manager (CSE) May 2025 – Written exam, question 13 of 16.
More from this paper
- Previous: Explain the differences between Second Normal Form (2NF) and Third Normal Form (3NF) with examples.
- Next: Write down the differences between Agile model and Waterfall model in Software development. What is white box testing?
- All questions in BPSC Network/Website Manager (CSE) May 2025 – Written