Using SSMS for Query Development | Dataford Interview Questions

What is your experience using SSMS (SQL Server Management Studio) for query development?

Demonstrate your approach with a PostgreSQL query against the provided query-run data. Return only successful runs and summarise performance for each developer, including rows where the developer is unidentified.

Output

One row per developer, with developer_name, successful_queries, and average_duration_ms.
Exclude unsuccessful runs, but include successful runs with a null duration in the count.
Sort by average duration descending, then developer name ascending, with null developer names last.

Schema

query_runs

Column	Type	Description
run_idPK	INT	Unique identifier for the query execution
developer_name	VARCHAR(100)	Name of the developer who ran the query
execution_status	VARCHAR(20)	Execution result status
duration_ms	INT	Execution duration in milliseconds

Your question is Using SSMS for Query Development. 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

What is your experience using SSMS (SQL Server Management Studio) for query development?

Output

One row per developer, with developer_name, successful_queries, and average_duration_ms.
Exclude unsuccessful runs, but include successful runs with a null duration in the count.
Sort by average duration descending, then developer name ascending, with null developer names last.

Schema

query_runs

Column	Type	Description
run_idPK	INT	Unique identifier for the query execution
developer_name	VARCHAR(100)	Name of the developer who ran the query
execution_status	VARCHAR(20)	Execution result status
duration_ms	INT	Execution duration in milliseconds

Your question is Using SSMS for Query Development. 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.