Reading Charts Under Pressure | Dataford Interview Questions

Explain what the graph or chart is showing and how you would use it to answer a risk-related question.

You are given chart observations captured from a Barclays risk dashboard. Write a SQL query that returns the latest observed value for each chart series, so the interviewer can see how you would summarize the chart before answering a risk question.

Output

One row per chart series
Columns: series_name, observation_date, metric_value
Return only the most recent observation for each series
Ignore rows where observation_date is NULL
Sort by series_name ascending

Schema

chart_observations

Column	Type	Description
observation_idPK	INT	Unique observation identifier
series_name	VARCHAR(100)	Name of the chart series
observation_date	DATE	Date the chart point was recorded
metric_value	NUMERIC(12,2)	Observed metric value

Your question is Reading Charts Under Pressure. 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

Explain what the graph or chart is showing and how you would use it to answer a risk-related question.

Output

One row per chart series
Columns: series_name, observation_date, metric_value
Return only the most recent observation for each series
Ignore rows where observation_date is NULL
Sort by series_name ascending

Schema

chart_observations

Column	Type	Description
observation_idPK	INT	Unique observation identifier
series_name	VARCHAR(100)	Name of the chart series
observation_date	DATE	Date the chart point was recorded
metric_value	NUMERIC(12,2)	Observed metric value

Your question is Reading Charts Under Pressure. 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.