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 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