list the name of the claim processing stage that most of the claims are on
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
what is the claim id of open
select claim_id from claims_processing_stages as t1 join claims_processing as t2 on t1.claim_stage_id = t2.claim_stage_id whereclaim_status_name = 'Open'
yes please
select distinct claim_stage_id from claims_processing