SQLSQL LabPostgreSQL practice
00:0028 / 45
W03Intermediaterunning total

Engineer deployment running total

For engineer 1, return deployment_id, deployed_at, and deployment_number, the running number of their releases. Sort chronologically.

Data available

Use this table

1 table
Table 1

deployments

Customer releases, including failures and rollbacks.

  • deployment_idintegerPK
  • customer_idintegerFK
  • engineer_idintegerFK
  • versiontext
  • statustext
  • deployed_attimestamptz
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.