The "Authors" column is now all filled in on the SQL Anywhere Technical Documents page, and the article counts look like this:
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.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
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 theUndisputed 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
No comments:
Post a Comment