DECLARE @emp_id INT
SET @emp_id = 2
SELECT     employee_1.emp_email 
FROM         employee INNER JOIN
                      request ON employee.emp_id = request.emp_id INNER JOIN
                      department ON employee.emp_department = department.department_id INNER JOIN
                      employee AS employee_1 ON department.department_contact_1 = employee_1.emp_id
WHERE employee.emp_id = @emp_id
GROUP BY employee_1.emp_email

EXEC msdb.dbo.sp_send_dbmail
    @recipients = 'me@myemail.com',
    @query = 'SELECT * FROM employee' ,
    @subject = 'Work Order Count',
    @attach_query_result_as_file = 1 ;