A recruiter on LinkedIn's recruiting team wants a quick way to look up employees whose name starts with a given letter. Using the employees table, return id, name, and department for all employees whose name begins with 'A', ordered by name ascending.
employees
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | INTEGER |
| id | name | department | salary |
|---|---|---|---|
| 1 | Alice | Engineering | 120000 |
| 2 | Bob | Marketing | 80000 |
| 3 | Aaron | HR | 65000 |
| 4 | Diana | Engineering | 95000 |
| 5 | Arthur | Marketing | 72000 |
| id | name | department |
|---|---|---|
| 3 | Aaron | HR |
| 1 | Alice | Engineering |
| 5 | Arthur | Marketing |
Aaron, Alice, and Arthur all start with "A" and are returned sorted alphabetically. Bob and Diana do not match and are excluded.