Using a noncorrelated subquery
each month a memo is that lists the employees who have employment anniversaries for that month is posted. create the report for the current month and list employee_id and the first and last names
for all employees hired during the current month of any year.

you can find employee_name in the orion. employee_addresses table and employee_hire_date in the orion. employee_payroll table. both tables contain the column employee_id. order the report by an employee's last name.

create a query that returns a list of employee ids for employees with a current anniversary.
the query should do the following:
display employee_id numbers.
use the orion. employee_payroll table.
return only employees whose hire date (employee_hire_date) is in the current month.
add a title to the report as shown.
partial proc sql output (generated when current month = february)

using the query in 1.a. as a noncorrelated subquery, write a query that displays the employee
ids and names of employees who have current month anniversaries. the final query should
do the following:
display employee_id and split employee_name into two new columns: firstname
and lastname. both new columns should have a length of $15 and appropriate labels.
(see the report below.) the original employee_name is stored as lastname, firstname.
use the orion. employee_addresses table.
select employee_id only for employees who had current month anniversaries.
order the final results by lastname.
create an appropriate title.
partial proc sql output (generated when current month = february)