Basic SQL Select Query | Dataford Interview Questions

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

Your question is Basic SQL Select Query. 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

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

Your question is Basic SQL Select Query. 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.