Build a deployment summary string for each deploy log in the format: '<service> v<version> deployed

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

Build a deployment summary string for each deploy log in the format: '<service> v<version> deployed to <env> in <seconds>s'. Return the result. Order by log_id and limit to 5 rows.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.