Wednesday, June 27, 2012

Who is "anon."?

The "Authors" column is now all filled in on the SQL Anywhere Technical Documents page, and the article counts look like this:

SELECT COUNT(*)                  AS article_count,
       sa_split_list.row_value   AS author
  FROM article CROSS APPLY sa_split_list ( article.authors, ',<br>' )
 GROUP BY author
 ORDER BY article_count DESC,
       author ASC;

288  anon.
 18  Joshua Savill
 17  -
 15  Reg Domaratzki
 14  Eric Farrar
 12  David Fishburn
 10  Chris Kleisath
 10  Dave Neudoerffer
 10  Glenn Paulley
 10  Jason Hinsperger
  9  José Ramos
  8  Bill Hillis
  8  Robert Waywell
  7  Alex Reif
  7  Liam Cavanagh
  7  Tom Slee
  5  Breck Carter
  5  Dan Farrar
  4  Anil K. Goel
  4  G. N. Paulley
  4  Mike Paola
  4  Russ Chamberlain
  3  Graham Hurst
  3  Ivan T. Bowman
  3  Jim Graham
  3  Matthew Young-Lai
  2  Ali Chalhoub
  2  Anil Goel
  2  David Loop
  2  Jonathan Greisz
  2  Mark Culp
  2  Martyn Mallick
  2  Paul Fast
  2  Philippe Bertrand
  2  Steven McDowell
  1  Anisoara Nica
  1  Anthony Scian
  1  Aylwin Lo
  1  B. Lucier
  1  Berndt Hamboeck
  1  Bill McCaslin
  1  Bob Holt
  1  Brad Coomes
  1  Brendan Lucier
  1  Chris Irie
  1  Dan Comfort
  1  Dan Lowe
  1  Darren D.V. Vaillant
  1  David Carson
  1  Deanne Chance
  1  Douglas Navas
  1  Eric Giguère
  1  Eric Murchie-Beyma
  1  Evguenia Eflov
  1  Geno Coschi
  1  Hong Shi
  1  Ian Thain
  1  Jagdish Bansiya
  1  James Blackstock
  1  James Parker
  1  Jay Hennings
  1  Jay J. Hennings
  1  John Smirnios
  1  Kurt Lichtner
  1  Kurt Trushenski
  1  Mark Wright
  1  Matt Carrier
  1  Paul A. Horan
  1  Peter Bumbulis
  1  Sam Lakkundi
  1  Shannon White
  1  Stephen Beck
  1  Todd A. Loomis
  1  Todd Loomis
  1  Trish Genoe
  1  Walt Tallman
Even if you accept that Glenn Paulley and G. N. Paulley are one and the same person and not friendly-versus-formal twins, anon. still outranks everyone by a wide margin.

Joshua Savill comes in a distant second, beating NULL who is represented in the list by the "-" character indicating an article that's missing an url for one reason or another.

But,

and this is important: Reg Domaratzki is now the

Undisputed Iron Man of Techwave

broken foot or not:
WITH count_by_author AS
        ( SELECT COUNT(*) AS article_count,
                 article.authors AS "Iron Men"
            FROM article
           WHERE article.title LIKE 'Techwave %'
             AND article.authors <> '-'
           GROUP BY article.authors ),
     count_by_iron_men AS
       ( SELECT MAX ( count_by_author.article_count ) AS article_count
           FROM count_by_author )
SELECT count_by_author.*
  FROM count_by_author 
          INNER JOIN count_by_iron_men
                  ON count_by_iron_men.article_count = count_by_author.article_count
 ORDER BY count_by_author."Iron Men";

article_count  Iron Men
15             Reg Domaratzki

Dilbert.com




No comments: