SQL Name Prefix Query

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

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

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

Tablesemployees

Your solutionPostgreSQL

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

Run a query to see results