Problem
HR systems commonly include name-search functionality for looking up employees quickly without knowing their full name. A recruiter might type "A" to find all employees whose first name begins with that letter when composing an email distribution list. Using the employees table, return id, name, and department for all employees whose name begins with 'A', ordered by name.
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 |