select
emp_lname

from new1.dbo.employee

where emp_no in (select emp_no
    from new1.dbo.works_on
    where project_no = (select project_no
        from new1.dbo.project
        where project_name='Apollo'
        )
    )