Select Code to Download

WITH
    Data(Ranking, Name, XP, Title, Writeups)
AS
...
     FROM    
        Step_XP_Writeups
    )

SELECT
    (SELECT COUNT(COUNT(*)) FROM Data GROUP BY XP, Writeups    HAVING 
+Count(*) > 1) Both,
    (SELECT COUNT(*) FROM Close) Close,
...
    Writeups_Diff_Avg
FROM
    MMA;

      BOTH      CLOSE         XP XP_DIFF_MIN XP_DIFF_MAX XP_DIFF_AVG  
+ WRITEUPS WRITEUPS_DIFF_MIN WRITEUPS_DIFF_MAX WRITEUPS_DIFF_AVG
---------- ---------- ---------- ----------- ----------- ----------- -
+--------- ----------------- ----------------- -----------------
         0          7         31           0      851484  1468.48538  
+      135            -56940             56902        .545321637
...
         0          5         30           0      845891  1451.52457  
+      135            -56761             56940        .780346821
         1          7         30           0      845449   1449.4329  
+      127            -56761             56940        .779220779
         1          8         33           0      844286  1449.44733  
+      130            -56761             56940        .779220779

SELECT
    Data.Ranking,
    Data.Name,
...
    Data.Ranking BETWEEN Close.Ranking AND Close.Ranking + 1
ORDER BY
    Data.Ranking;

   RANKING NAME                         XP TITLE             WRITEUPS
---------- -------------------- ---------- --------------- ----------
        37 eyepopslikeamosquito      29895 Canon (20)            1289
...
       665 giulienk                   3085 Curate (13)            122

14 rows selected.