一、题目
二、代码
# Write your MySQL query statement below
#窗口函数 非常巧妙
-- select * from Insurance partition 分区
select round(sum(table1.tiv_2016),2) as tiv_2016 from
(
select tiv_2016 ,
count(*) over(partition by tiv_2015 ) as co15,
count(*) over(partition by lat,lon) as co_lat_lon
from Insurance
) as table1
where table1.co15>1 and table1.co_lat_lon = 1