SQL error: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'dent_health.healthcare_dataset.MedicalCondition'; this is incompatible with sql_mode=only_full_group_by running query

---

SELECT MedicalCondition, AVG(Age) AS AverageAge, MIN(Age) AS LowAge, MAX(Age) AS HighAge, COUNT(Name) AS NumberPatients FROM healthcare_dataset

---