Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit 9eddb78

Browse filesBrowse files
committed
Update README.md
1 parent 1245451 commit 9eddb78
Copy full SHA for 9eddb78

File tree

1 file changed

+9
-0
lines changed
Filter options

1 file changed

+9
-0
lines changed

‎README.md

Copy file name to clipboardExpand all lines: README.md
+9Lines 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)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.