SQL, APIs, and OOP | Dataford Interview Questions

Explain how you use SQL queries and APIs together, and how OOP concepts show up in your personal projects.

For a representative implementation, write a query over the supplied API request and SQL execution records, then explain how an application could expose or consume this data through an API.

Output

One row per non-null endpoint with at least two requests during January 2026
Columns: endpoint, request_count, successful_request_count, avg_sql_duration_ms, and sql_execution_count
Order by successful requests descending, then endpoint ascending

Schema

api_requests

Column	Type	Description
request_idPK	INT	Unique API request identifier
endpoint	VARCHAR(100)	Requested API endpoint
response_status	INT	HTTP response status code
requested_at	TIMESTAMP	Time when the API request was received

sql_executions

Column	Type	Description
execution_idPK	INT	Unique SQL execution identifier
request_id	INT	API request associated with the SQL execution
duration_ms	DECIMAL(10,2)	SQL execution duration in milliseconds

Your question is SQL, APIs, and OOP. Start with the requirements and the two tables 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