Table of Contents
Challenges MediumSQL (Intermediate) – HackerRank Solution SQL, Best and Optimal Solutions , All you need.
Solutions of SQL all HackerRank:
Here are all the Solutions of All of SQL of Hacker Rank , Leave a comment for similar posts
SQL Challenges MediumSQL (Intermediate) HackerRank Solution
select h.hacker_id, h.name, count(*) from Hackers h inner join Challenges c on h.hacker_id=c.hacker_id
where h.hacker_id not in
(select t1.hacker_id
from(select hacker_id, count(*) as cnt from Challenges group by hacker_id) as t1
inner join
(select hacker_id, count(*) as cnt from Challenges group by hacker_id) as t2 on t1.hacker_id!=t2.hacker_id and t1.cnt=t2.cnt and t1.cnt != (select count(*) from Challenges group by hacker_id order by count(*) desc limit 1))
group by h.hacker_id
order by count(*) desc, h.hacker_id
SQL (Basic)
SQL (Intermediate)
SQL (Advanced)
Basic Select
Advanced Select
Aggregation
Basic Join
Advanced Join
Alternative Queries
Leave a comment below
Related posts:
Binary Tree Nodes MediumSQL (Intermediate) – SQL – HackerRank Solution
New Companies MediumSQL (Intermediate) – SQL – HackerRank Solution
Weather Observation Station 20 MediumSQL (Intermediate) – SQL – HackerRank Solution
The Report MediumSQL (Intermediate) – SQL – HackerRank Solution
Top Competitors MediumSQL (Intermediate) – SQL – HackerRank Solution
Ollivander’s Inventory MediumSQL (Intermediate) – SQL – HackerRank Solution
