Find Employees Starting With A | Dataford Interview Questions

The Argus Information & Advisory Services employee directory is used for internal reporting and contact management. Write a PostgreSQL query to find employees whose names begin with the uppercase letter A.

Requirements

Return the employee names that match the prefix A.
Sort the matching names alphabetically.
Exclude NULL names, empty names, and names beginning with other letters.

Schema

employee_directory

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(150)	Employee's full name
department	VARCHAR(100)	Employee's department
office_location	VARCHAR(100)	Employee's office location

Your question is Find Employees Starting With A. 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

Requirements

Return the employee names that match the prefix A.
Sort the matching names alphabetically.
Exclude NULL names, empty names, and names beginning with other letters.

Schema

employee_directory

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(150)	Employee's full name
department	VARCHAR(100)	Employee's department
office_location	VARCHAR(100)	Employee's office location

Your question is Find Employees Starting With A. 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.