O01AdvancedCTE · conditional metrics

Customer pipeline reliability

For customers with at least five completed pipeline runs, return customer_id, completed_runs, and success_pct, rounded to one decimal. Exclude running jobs and show lowest reliability 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.