SQL Starts With 'A'

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL Starts 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

Finastra maintains employee records supporting products such as FusionFabric.cloud. Write a PostgreSQL query to identify employees whose names start with the uppercase letter A.

Requirements

Return each matching employee_name exactly once.
Exclude NULL names and names beginning with other letters.
Sort the results alphabetically by employee_name.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(120)	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