SQL Starts With 'A'

EasySQL · PostgreSQL

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

CodePostgreSQL

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

Run your query to see results here.