almost there 8 subquers and joins

SELECT  op.EmployeeID,op.FirstName,op.Name AS 'ProjectName'
         FROM (
            SELECT CASE
              WHEN
                YEAR(p.StartDate) >=2005
                  THEN


            END

        AS p.Name,e.FirstName,e.EmployeeID
        FROM Employees AS e
        INNER JOIN EmployeesProjects AS ep ON e.EmployeeID=ep.EmployeeID
        INNER JOIN Projects AS p ON p.ProjectID=ep.ProjectID
        ) AS op

WHERE op.EmployeeID=24