Slow Batch Jobs

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

Domain

SQL

Difficulty

easy

Seniority

senior

Problem

Find every batch job where the ended timestamp is later than the started timestamp (meaning it actually completed). For each, compute how many minutes elapsed between start and end. Return job_id, job_name, and minutes_elapsed.

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.