Write a basic SQL query to retrieve data from a table with a simple filter.
Use the employees table and return employees whose department is Engineering.
employee_id, employee_name, and job_title.employee_id in ascending order.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee full name |
| department | VARCHAR(80) | Employee department |
| job_title | VARCHAR(120) | Employee job title |
| employment_status | VARCHAR(30) | Current employment status |