select count(*) from recruiting_interviews i where i.interviewer_id = :user_id and (select count(*) from recruiting_ratings r where r.interview_id = i.interview_id) = 0 select count(*) from recruiting_interviews i where i.interviewer_id = :user_id and (select count(*) from recruiting_ratings r where r.interview_id = i.interview_id) != 0