What is the least frequent claim outcome?
select claim_outcome_code from claims_processing group by claim_outcome_code order by count(claim_outcome_code) asc limit 1
Most frequent?
select claim_outcome_code from claims_processing group by claim_outcome_code order by count(claim_outcome_code) desc limit 1
Show for claim status instead.
select t2.claim_status_name from claims_processing as t1 join claims_processing_stages as t2 on t1.claim_stage_id = t2.claim_stage_id group by t1.claim_stage_id order by count(*) desc limit 1