Your question is Basic SQL Select Query. 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.
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.
employee_id in ascending order so the extract is consistently ordered.| 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 |
| VARCHAR(150) | Employee's work email address |