Employee Name Search - Easy SQL Filtering Interview Problem

Problem

A recruiter types the letter "A" into a search bar to find every candidate whose name starts with that letter. Let's assume that this search bar automatically sends a query to a database. What might that query look like? Using the employees table, return id, name, and department for all employees whose name begins with 'A', ordered by name descending.

Schema

employees

column	type
id	INTEGER
name	TEXT
department	TEXT
salary	INTEGER

Sample Data

id	name	department	salary
1	Alice	Engineering	120000
2	Bob	Marketing	80000
3	Aaron	HR	65000
4	Diana	Engineering	95000
5	Arthur	Marketing	72000

Expected Output

id	name	department
3	Aaron	HR
1	Alice	Engineering
5	Arthur	Marketing

Hints