Merge-Triggered Builds 2026

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

Domain

SQL

Difficulty

easy

Problem

Scope to ci_builds rows whose built_at year equals 2026 AND trigger != 'manual' AND branch is either 'main' or 'release'. For each of the two branches, return one row with the branch label, count of builds (as integer), the same count cast to REAL, and AVG(dur_secs). Return two rows sorted alphabetically by branch.

Practice This Problem

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