Find Tests With No Recent Execution

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Find Tests With No Recent Execution. Start with the requirements and the two tables on the right.

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

You need to log in / sign up to run or submit.

Problem

Apex Systems QA engineers use the Apex Test Hub to monitor automated and manual test coverage. Write a PostgreSQL query that identifies tests with no execution history during the last 60 calendar days.

Requirements

Return each qualifying test's ID, name, product area, and owner.
Include tests that have never been executed and tests whose executions are all older than 60 days.
Exclude executions dated in the future, and sort the results by test ID.

Schema

tests

Column	Type	Description
test_idPK	INTEGER	Unique test identifier
test_name	VARCHAR(150)	Test name
product_area	VARCHAR(80)	Product or feature area
owner_name	VARCHAR(100)	Assigned test owner

test_executions

Column	Type	Description
execution_idPK	INTEGER	Unique execution identifier
test_id	INTEGER	Referenced test identifier
executed_at	TIMESTAMPTZ	Execution timestamp
execution_status	VARCHAR(20)	Execution result

Tablesteststest_executions

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results