select 
	mt.description TYPES_OF_MISSIONS
from
	mission_types mt
	inner join missions m	on
		m.mission_type_id=mt.mission_type_id
	inner join missions_agents ma on
                ma.mission_id=m.mission_id
        inner join agents a on
                a.agent_id=ma.agent_id
where 
            a.security_level IN
		(
		select 
		max(a.security_level)
		from
		agents a
		)
order by
	m.mission_id
;