SQL Name Prefix Query | Dataford Interview Questions

ISS STOXX maintains employee records used in internal quality assurance and access-control workflows. Write a PostgreSQL query to return employees whose names start with the letter A, regardless of whether the stored name uses uppercase or lowercase letters.

Requirements

Return only the employee_name column.
Match names beginning with A case-insensitively and sort the results alphabetically.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Employee's department

Your question is SQL Name Prefix Query. 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 only the employee_name column.
Match names beginning with A case-insensitively and sort the results alphabetically.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Employee's department

Your question is SQL Name Prefix Query. 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.