This SQL query look unreal

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

select Outcomes.ship,count(*)
from Outcomes
where outcomes.result!='sunk'
group by ship
HAVING count(*)>=2
union
select ships.name,count(*)
from ships
where ships.launched!=NULL
group by name
HAVING count(*)>=2