• Als Spam markieren
• Beitrag melden

• 
  Diese Gruppe Alles

• Archiv
• RSS-Feeds

• Kontakt
• Hilfe
• Impressum
• Datenschutz

Re: ~Interesting stat factoid

Stats schrieb:
>   I've been playing around after populating a (test)
> database with news articles (I think it was 2005 when
> I first mentioned I was planning on finding that
> particular round tuit) and have been comparing and
> relating all sorts of data.  Here's a comparison that
> struck me as almost dramatic.
>
>   How many distinct From addresses were used to post
> to alt.coffee in May of 2008?
>
> SELECT COUNT(DISTINCT Sender) as Senders
> FROM alt_coffee
> WHERE Date like '%2008%'
> AND Date like '%May%';
> +---------+
> | Senders |
> +---------+
> |     146 |
> +---------+
> 1 row in set (1.60 sec)
>
>   Ditto for 2003:
>
> SELECT COUNT(DISTINCT Sender) as Senders
> FROM alt_coffee
> WHERE Date like '%2003%'
> AND Date like '%May%';
> +---------+
> | Senders |
> +---------+
> |     640 |
> +---------+
> 1 row in set (1.60 sec)

Crazy stats. Gimme more!!! It's interesting!