1、题目描述
来源:力扣(LeetCode)
2、解题思路
1# 第一个子表,按TIV_2015
分组,统计数量,取大于1的值
2# 第二个子表,按LAT,LON
分组,统计数量,取等于1的值
3# 2表联查
3、提交记录
select sum(TIV_2016) as TIV_2016
from(
select TIV_2015,count(*) as cou_2015
from insurance
group by TIV_2015
having cou_2015>1) a,
(select *,count(*) as cut_lat
from insurance
group by LAT,LON
having cut_lat=1) add_lat
where a.TIV_2015=add_lat.TIV_2015
761ms