SQLSQL LabPostgreSQL practice
00:0012 / 45
J06Intermediatemulti-table joins

Release ownership detail

For rolled-back deployments, return deployment_id, customer_name, engineer_name, team, and deployed_at. Sort newest first.

Data available

Use these tables

3 tables · 2 relationships
Table 1

deployments

Customer releases, including failures and rollbacks.

  • deployment_idintegerPK
  • customer_idintegerFK
  • engineer_idintegerFK
  • versiontext
  • statustext
  • deployed_attimestamptz
Table 2

customers

Organizations using the deployed platform.

  • customer_idintegerPK
  • nametext
  • industrytext
  • regiontext
  • tiertext
  • onboarded_attimestamptz
Table 3

engineers

Forward-deployed engineers who own releases.

  • engineer_idintegerPK
  • nametext
  • teamtext
How the tables connect
deployments.customer_id=customers.customer_iddeployments.engineer_id=engineers.engineer_id
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.