SQL Selection by Prefix

EasySQL · PostgreSQL

Problem

Accion Labs maintains an employee directory for internal search and reporting. Write a PostgreSQL query to find directory entries for employees whose names start with the uppercase letter G.

Requirements

Return the employee name and team.
Include only names beginning with uppercase G, and sort the results alphabetically by employee name.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee display name
team	VARCHAR(80)	Accion Labs team assignment
location	VARCHAR(80)	Primary work location

Tablesemployees

CodePostgreSQL

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

Run your query to see results here.