Can anyone help me figure out why my solution is wrong?


  • 0
    N

    SELECT ROUND(SUM(tt.TIV_2016),2) AS TIV_2016
    FROM(
    SELECT SUM(t.TIV_2016) AS TIV_2016
    FROM(
    SELECT TIV_2015, TIV_2016
    FROM insurance
    GROUP BY LAT,LON
    HAVING COUNT(*) = 1) AS t
    GROUP BY t.TIV_2015
    HAVING COUNT(TIV_2016) > 1) AS tt


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.