Summarize Metrics With GROUP BY | Dataford Interview Questions

How would you write a query using GROUP BY to summarize client metrics?

Assume the client_metrics table contains metric observations. Include only rows with a valid status and summarize non-null metric values for each client.

Output

One row per client with valid records
Columns: client_name, metric_count, total_metric_value, average_metric_value, and maximum_metric_value
Sort by total value descending, place null totals last, then sort client names ascending

Schema

client_metrics

Column	Type	Description
metric_idPK	INT	Unique identifier for the metric observation
client_name	VARCHAR(100)	Client associated with the observation
metric_value	DECIMAL(12,2)	Numeric value of the observation
metric_status	VARCHAR(20)	Whether the observation is valid

Your question is Summarize Metrics With GROUP BY. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem