Skip to content
LakeBench
ProblemsCommunityPricing
Sign inStart practicing

Names starting with A

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

Find employees whose name starts with 'A'. Columns: employee_id, name. Order by name.

Constraints

  • Matching is case-sensitive on this seed (names are title case).
  • Return exactly these columns: employee_id, name.

Examples

Input: employees employee_id | name 1 | Alice Chen 2 | Bob Kumar 5 | Omar Ali Output: employee_id | name 1 | Alice Chen Why this passes: LIKE 'A%' matches the first character only. Bob and Omar are excluded.

Topics: lakebench, sql, like, strings.

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

beginner

Names starting with A

Interview-style drill: LIKE filter for employee names starting with A.

Find employees whose `name` starts with 'A'. Columns: `employee_id`, `name`. Order by `name`.