Find the total number of patients, the number of male patients and the number of female patients, each in its own column total_patients, M_patients, F_total_patients. The result must be returned in a single row.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
You need three numbers in one row: think of one aggregate per column, each with its own condition.