ieshreya
diff --git a/‎README.md
Copy file name to clipboardExpand all lines: README.md
+9Lines changed: 9 additions & 0 deletions b/‎README.md
Copy file name to clipboardExpand all lines: README.md
+9Lines changed: 9 additions & 0 deletions
@@ -627,3 +627,12 @@ ORDER BY num DESC
 LIMIT 1
 ```
 
+[585. Investments in 2016](https://leetcode.com/problems/investments-in-2016)
+```sql
+SELECT
+    ROUND(SUM(tiv_2016),2) AS tiv_2016
+FROM insurance
+WHERE tiv_2015 IN (SELECT tiv_2015 FROM insurance GROUP BY tiv_2015 HAVING COUNT(*) > 1)
+AND (lat,lon) IN (SELECT lat,lon FROM insurance GROUP BY lat,lon HAVING COUNT(*) = 1)
+```
+