Find Employees Starting With A

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

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

You need to log in / sign up to run or submit.

Problem

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

Tablesemployee_directory

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results