SELECT p.pat_name
     , ec.eva_category_name
  FROM sickness            s
     , emt_sickness        es
     , emt                 e
     , reception           r
     , patient             p
     , evacuation_category ec
 WHERE s.sickness_id     = es.sickness_id
   AND es.emt_id         = e.emt_id
   AND e.reception_id    = r.reception_id
   AND r.patient_id      = p.patient_id
   AND r.eva_category_id = ec.eva_category_id
   AND s.sickness_name   = '감기'
;

SELECT p.pat_name
     , ec.eva_category_name
  FROM sickness s
 INNER JOIN emt_sickness        es ON s.sickness_id     = es.sickness_id
 INNER JOIN emt                 e  ON es.emt_id         = e.emt_id
 INNER JOIN reception           r  ON e.reception_id    = r.reception_id
 INNER JOIN patient             p  ON r.patient_id      = p.patient_id
 INNER JOIN evacuation_category ec ON r.eva_category_id = ec.eva_category_id
 WHERE s.sickness_name = '감기'
;