1.
select 舰艇名称
from outcomes
group by 战役
having count(舰艇名称)>12.
select 战役
from outcomes
where 舰艇名称 in
(select 舰艇名称 from outcoumes o join ships s
on o.舰艇名称=s.舰艇名称
join classes c
on c.等级=s.等级
group by 舰艇名称
having count(*)>=3 )
select 舰艇名称
from outcomes
group by 战役
having count(舰艇名称)>12.
select 战役
from outcomes
where 舰艇名称 in
(select 舰艇名称 from outcoumes o join ships s
on o.舰艇名称=s.舰艇名称
join classes c
on c.等级=s.等级
group by 舰艇名称
having count(*)>=3 )
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货