Activity Participants

LeetCode Link

Problem Description

Visit LeetCode for the full problem description.

---

Solutions

Solution 1: MS SQL (Best: 861 ms)

Metric	Value
Runtime	861 ms
Memory	0B
Date	2020-02-26

Solution

/* Write your T-SQL query statement below */
WITH CTE AS
(
  SELECT activity, count(*) as activity_count FROM Friends
  GROUP BY activity
 )
 SELECT activity FROM CTE WHERE activity_count 
 NOT IN (SELECT MIN(activity_count) FROM CTE UNION SELECT MAX(activity_count) FROM CTE)

📜 1 more MS SQL submission(s)

Submission (2020-02-26) — 1489 ms, 0B

/* Write your T-SQL query statement below */
WITH CTE AS
(
  SELECT activity, count(*) as activity_count FROM Friends
  GROUP BY activity
 )
SELECT activity FROM (
SELECT activity, 
RANK() OVER(ORDER BY activity_count) AS RANK_ASC,
RANK() OVER(ORDER BY activity_count DESC) AS RANK_DSC
FROM CTE
 ) R
WHERE RANK_ASC <> 1 AND RANK_DSC<>1

---

Complexity Analysis

Approach	Time	Space
Solution	To be analyzed	To be analyzed