95th Percentile Latency SQL | Dataford Interview Questions

Given a table of API response times, write a query to find the 95th percentile of latency per day.

Use PostgreSQL syntax. Ignore NULL latency values when calculating the percentile.

Output

api_response_times

Column	Type	Description
response_idPK	INT	Unique identifier for the API response record
response_at	TIMESTAMP	Timestamp when the API response was recorded
latency_ms	NUMERIC(10,2)	API response latency in milliseconds
endpoint	VARCHAR(100)	API endpoint that produced the response

Your question is 95th Percentile Latency SQL. 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.

Given a table of API response times, write a query to find the 95th percentile of latency per day.

Use PostgreSQL syntax. Ignore NULL latency values when calculating the percentile.

api_response_times

Column	Type	Description
response_idPK	INT	Unique identifier for the API response record
response_at	TIMESTAMP	Timestamp when the API response was recorded
latency_ms	NUMERIC(10,2)	API response latency in milliseconds
endpoint	VARCHAR(100)	API endpoint that produced the response

Your question is 95th Percentile Latency SQL. 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.