This SQL query look unreal

Member

adelia_boyer

by adelia_boyer , in category: SQL , 2 months ago

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


Facebook Twitter LinkedIn Telegram Whatsapp Pocket

no answers