A company needs to analyze its recent hiring trends. Write a SQL query to find all employees who joined within the last year from today's date.
join_date to include only those who joined in the last year.employee_id, first_name, last_name, and join_date.employees (employee_id, first_name, last_name, join_date)
| employee_id | first_name | last_name | join_date |
|---|---|---|---|
| 1 | John | Doe | 2023-09-15 |
| 2 | Jane | Smith | 2022-06-20 |
| 3 | Alice | Johnson | 2023-11-10 |
| 4 | Bob | Brown | 2021-08-30 |
| 5 | Charlie | Davis | 2023-05-25 |
| employee_id | first_name | last_name | join_date |
|---|---|---|---|
| 1 | John | Doe | 2023-09-15 |
| 3 | Alice | Johnson | 2023-11-10 |
| 5 | Charlie | Davis | 2023-05-25 |