select count(*) as status_types_defined_p from recruiting_status_types where enabled_p = 't'; select count(*) as criteria_defined_p from recruiting_critera where enabled_p = 't'; select count(*) as num_candidates from recruiting_candidates select count(*) as pending_interviews from recruiting_interviews i where (select count(*) from recruiting_ratings r where r.interview_id = i.interview_id) = 0