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.

sorry, we won't do your homework for you

what have you tried on your own?

Show us what you tried and we can give you hints.