SQL Names Starting With A | Dataford Interview Questions

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

Your question is SQL Names Starting With A. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

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

Your question is SQL Names Starting With A. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.