sql42专题

sql42(585 2016年的投资)

代码: # Write your MySQL query statement belowselect round(sum(t.tiv_2016),2) as tiv_2016from(select distinct(t1.pid),t1.tiv_2016from Insurance t1,Insurance t2where t1.tiv_2015=t2.tiv_2015 and t1.pid!