Starts With A
employees lists people by name, each written with a capital first letter. Return the name of everyone whose name starts with A. Rows may come in any order.
Example 1
employees
| id | name | dept |
|---|---|---|
| 1 | Ada | ops |
| 2 | Ben | risk |
| 3 | Maria | ops |
| 4 | Alan | tech |
returns
| name |
|---|
| Ada |
| Alan |
Constraints
- Up to 12 people
- Names are unique
Write it in your browser, against the clock. The model query, with a note on each piece of it, comes after.
More SQL problems
- Three LargestBeginner
- Trade ValueBeginner
- Two ColumnsBeginner
- Average per SymbolEasy
- Biggest SpenderEasy
- Bought and SoldEasy
- Busy SymbolsEasy
- Buyers per ProductEasy