Your question is SQL Selection by Prefix. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Accion Labs maintains an employee directory for internal search and reporting. Write a PostgreSQL query to find directory entries for employees whose names start with the uppercase letter G.
G, and sort the results alphabetically by employee name.| Column | Type | Description |
|---|---|---|
| employee_idPK | INTEGER | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee display name |
| team | VARCHAR(80) | Accion Labs team assignment |
| location | VARCHAR(80) | Primary work location |