Create investments-in-2016.sql

kamyu104 · web-flow · commit 99fbeed2f97c · 2017-11-16T09:23:57.000-06:00
diff --git a/MySQL/investments-in-2016.sql b/MySQL/investments-in-2016.sql
@@ -0,0 +1,29 @@
+# Time:  O(n^2)
+# Space: O(n)
+
+SELECT
+    SUM(insurance.TIV_2016) AS TIV_2016
+FROM
+    insurance
+WHERE
+    insurance.TIV_2015 IN
+    (
+      SELECT
+        TIV_2015
+      FROM
+        insurance
+      GROUP BY TIV_2015
+      HAVING COUNT(*) > 1
+      ORDER BY NULL
+    )
+    AND CONCAT(LAT, LON) IN
+    (
+      SELECT
+        CONCAT(LAT, LON)
+      FROM
+        insurance
+      GROUP BY LAT , LON
+      HAVING COUNT(*) = 1
+      ORDER BY NULL
+    )
+;
