Standout Clinics

Problem

A health network records monthly metrics for each clinic.

Table: metric
+-------------+--------------+
| Column Name | Type |
+-------------+--------------+
| clinic_id | int |
| metric_name | varchar(255) |
| tally | int |
+-------------+--------------+
(clinic_id, metric_name) is the primary key. Each row holds one clinic's tally for one metric (such as 'visits', 'referrals', or 'screenings').

Write a solution to find all standout clinics. A clinic is a standout when it beats the network-wide average for more than one metric, where beating means its tally for that metric is strictly greater than the average tally of that same metric across all clinics. Return a single column clinic_id in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns clinic_id.

Starter code (SQL)

SELECT *
FROM metric;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium