Winning Candidate

LeetCode Link

Problem Description

Visit LeetCode for the full problem description.

---

Solutions

Solution 1: MS SQL (Best: 933 ms)

Metric	Value
Runtime	933 ms
Memory	0B
Date	2020-02-04

Solution

/* Write your T-SQL query statement below */
WITH CTE AS
(
SELECT RANK() OVER (ORDER BY COUNT(*) DESC) AS RNK,
CandidateId,
COUNT(*) AS CNT
FROM Vote
GROUP BY CandidateId
)
SELECT Name FROM Candidate
WHERE id in (SELECT CandidateId FROM CTE WHERE RNK=1)

📜 2 more MS SQL submission(s)

Submission (2020-02-04) — 1247 ms, 0B

/* Write your T-SQL query statement below */
select TOP 1 Name from 
(select count(*) As CNT, Name from Candidate C
join Vote V on V.CandidateId = C.id
group by Name) AS J
ORDER BY CNT DESC

Submission (2020-02-04) — 1265 ms, 0B

/* Write your T-SQL query statement below */
WITH CTE AS
(
SELECT CandidateId,
COUNT(*) AS CNT
FROM Vote
GROUP BY CandidateId
)
SELECT Name FROM Candidate
WHERE id in (SELECT TOP 1 CandidateId FROM CTE ORDER BY CNT DESC )

---

Complexity Analysis

Approach	Time	Space
Solution	To be analyzed	To be analyzed