Longest Deploy With Full Identifier

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

Domain

SQL

Difficulty

easy

Seniority

junior

Problem

We need full identification for the deployment(s) with the longest duration. Show a label combining the service name and version, along with the duration in seconds. If multiple deployments tie for the longest, include all of them.

Practice This Problem

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