Diagnosis Frequency

Write a SQL query to find the most common diagnosis and its frequency.

Expected Columns

• diagnosis
• frequency
• percentage

Example Output

| diagnosis | frequency | percentage | |-----------|-----------|------------| | Hypertension | 1 | 9.09 | | Follow-up | 1 | 9.09 | | ... | ... | ... |