This query works in getting the number of challenges created by each hacker. I don't really care about the order in this case, I just have the Order By for viewing intermediate results.
Select c2.hacker_id, Count(c2.challenge_id) cnt2 From Challenges as c2 Group By c2.hacker_id Order By cnt2 Desc;
I received the error:
Select *, count(ch.cnt2) cnt1 From (Select c2.hacker_id, Count(c2.challenge_id) cnt2 From Challenges as c2 Group By c2.hacker_id) ch, Challenges c1 Group By cnt1;
ERROR 1056 (42000) at line 1: Can't group on 'cnt1'.
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.