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

L5

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.

Summary

Promised by noon. Delivered at midnight.

Practice This Problem

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