mysql语句

select DISTINCT case_id,status, num FROM (SELECT s.case_id ,
s.status,
CASE s.status WHEN 'done' THEN 0
WHEN 'invalid' THEN 1
WHEN 'plan' THEN 2
WHEN 'pretrial' THEN 3
WHEN 'trialing' THEN 4 END AS num

FROM lassen_court_schedule s )t WHERE t.num=0 ORDER BY case_id ;

select distinct case_id from lassen_court_schedule where case_id not in (select case_id from lassen_court_schedule where status<>'done' ) ORDER BY case_id ;