gistfile1.txt

mysql> select count(*) from users U join challenges C where C.level=10;
+----------+
| count(*) |
+----------+
|     7296 | 
+----------+
1 row in set (0.01 sec)

mysql> select count(*) from users U inner join challenges C on U.challenge_id = C.id where C.level=10;
+----------+
| count(*) |
+----------+
|       61 | 
+----------+
1 row in set (0.01 sec)