I have difficulty in creating a query for the question below, please can you help? You can also forward the suggested answers to my other e-mail address which is becktoria@cooltoad.com

Write a query that displays the employee id, last name, job id and hire date of all those employees who were hired within the last seven days of a month. Rename the Column names to appear as ID, Surname, Job Title and Date hired respectively.

thank you in advance.