SQLSQL LabPostgreSQL practice
00:004 / 45
D04CoreDISTINCT

Connected source inventory

Return one column, source_name, containing each pipeline source exactly once, alphabetically.

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.