SQL Names Starting With A

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

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

ISS Governance needs a simple employee directory filter for names beginning with the uppercase letter A. Write a PostgreSQL query against the Employee table.

Requirements

Return the employee names that begin with A.
Sort the results alphabetically by name.
Do not return NULL, empty, or lowercase a names.

Schema

employee

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
name	VARCHAR(100)	Employee display name
department	VARCHAR(80)	Employee department

Tablesemployee

Your solutionPostgreSQL

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

Run a query to see results