Basic SQL Select Query

EasySQL · PostgreSQL

Problem

Healthfirst needs a complete employee extract for a Business Analyst review of workforce records across New York operations. Write a PostgreSQL query that retrieves every column from the employees table.

Requirements

Return all columns without manually listing individual columns.
Sort the results by employee_id in ascending order so the extract is consistently ordered.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Healthfirst department
job_title	VARCHAR(100)	Employee's job title
work_location	VARCHAR(80)	Primary work location
email	VARCHAR(150)	Employee's work email address

Tablesemployees

CodePostgreSQL

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

Run your query to see results here.