8000 Update README.md · Atharv625/sql-50-leetcode@9eddb78 · GitHub
[go: up one dir, main page]
Skip to content

Commit 9eddb78

Browse files
ieshreyaieshreya
committed
Update README.md
1 parent 1245451 commit 9eddb78

File tree

1 file changed

+9
-0
lines changed

1 file changed

+9
-0
lines changed

‎README.md

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -627,3 +627,12 @@ ORDER BY num DESC
627627
LIMIT 1
628628
```
629629

630+
[585. Investments in 2016](https://leetcode.com/problems/investments-in-2016)
631+
```sql
632+
SELECT
633+
ROUND(SUM(tiv_2016),2) AS tiv_2016
634+
FROM insurance
635+
WHERE tiv_2015 IN (SELECT tiv_2015 FROM insurance GROUP BY tiv_2015 HAVING COUNT(*) > 1)
636+
AND (lat,lon) IN (SELECT lat,lon FROM insurance GROUP BY lat,lon HAVING COUNT(*) = 1)
637+
```
638+

0 commit comments

Comments
 (0)
0