Select Code to Download

WITH
    Data(Ranking, Name, XP, Writeups)
AS
...
     WHEN '<=0'    THEN 6
     WHEN 'nan'    THEN 7
    END;

NAME      COUNT(*)
------- ----------
1-9            135
...
nan              2

7 rows selected.