Content-Length: 299512 | pFad | http://github.com/iamAntimPal/LeetCode_SQL_Database/discussions/29

A4 LeetCode Problam · iamAntimPal LeetCode_SQL_Database · Discussion #29 · GitHub
Skip to content

LeetCode Problam #29

Answered by iamAntimPal
IamShiwangi asked this question in Q&A
Mar 21, 2025 · 1 comments · 1 reply
Discussion options

You must be logged in to vote
WITH
  InsuranceWithCounts AS (
    SELECT
      tiv_2016,
      COUNT(*) OVER(PARTITION by tiv_2015) AS tiv_2015_count,
      COUNT(*) OVER(PARTITION by lat, lon) AS city_count
    FROM Insurance
  )
SELECT ROUND(SUM(tiv_2016), 2) AS tiv_2016
FROM InsuranceWithCounts
WHERE tiv_2015_count > 1
  AND city_count = 1;

Explanation

Replies: 1 comment 1 reply

Comment options

You must be logged in to vote
1 reply
@IamShiwangi
Comment options

Answer selected by IamShiwangi
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/iamAntimPal/LeetCode_SQL_Database/discussions/29

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy