Skip to content
LakeBench
ProblemsCommunityPricing
Sign inStart practicing

Hired in 2023

SQL data engineering interview problem. Difficulty: beginner. Pattern: Date Functions. About 8 minutes. Free to practice.

Find employees hired in 2023. Columns: name, hire_date. Order by hire_date, then name.

Constraints

  • Use an inclusive start and exclusive end bound on hire_date.
  • Return exactly these columns: name, hire_date.

Examples

Input: employees name | hire_date Bob Kumar | 2023-03-01 Eve Ng | 2024-01-05 Max Reed | 2023-12-01 Output: name | hire_date Bob Kumar | 2023-03-01 Max Reed | 2023-12-01 Why this passes: Eve is 2024 and drops out. Prefer a date range over YEAR(hire_date) = 2023.

Topics: lakebench, sql, dates, where.

More SQL interview questions · All interview problems · Learn data engineering

beginner

Hired in 2023

Interview-style drill: Filter employees hired during calendar year 2023.

Find employees hired in 2023. Columns: `name`, `hire_date`. Order by `hire_date`, then `name`.