SQL Selection by Prefix | Dataford Interview Questions

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.

Requirements

Return the employee name and team.
Include only names beginning with uppercase G, and sort the results alphabetically by employee name.

Schema

employees

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

Your question is SQL Selection by Prefix. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

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.

Requirements

Return the employee name and team.
Include only names beginning with uppercase G, and sort the results alphabetically by employee name.

Schema

employees

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

Your question is SQL Selection by Prefix. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.