A06IntermediateSUM · NULLIF

Pipeline record retention

For succeeded runs, return source_name and retention_pct as 100 × total records_out / total records_in, rounded to two decimals. Sort highest first.

Data available

Use this table

1 table

Table 1

pipeline_runs

Data ingestion jobs from four upstream sources.

run_idintegerPK
customer_idintegerFK
source_nametext
statustext
started_attimestamptz
completed_attimestamptzNULL
records_ininteger
records_outintegerNULL

Query editor

PostgreSQL

⌘↵ Run query

Result stream

Output

Run your query to inspect its result.

Contextual coach

Ask about this attempt

Run or check a query first. The coach only comments on a real error or grader mismatch.

Field notes

Hints & explanation

Try to solve it cold. Two progressive hints are available.