select cr.criteria_id, cr.criteria_name, cr.description, r.rating from recruiting_criteria cr, recruiting_ratings r where r.interview_id = :interview_id and r.criteria_id = cr.criteria_id select round(avg(r.rating),1) from recruiting_ratings r where r.interview_id = :interview_id select (CASE WHEN i.should_hire_p = 't' THEN 'Yes' WHEN i.should_hire_p = 'f' THEN 'No' END) as should_hire_p from recruiting_interviews i where i.interview_id = :interview_id