Tech Tantra Thursday - Bill Eberle

a simple site for sharing ideas

tech tantra thursday
- behind the cosmic curtain with Bill Eberle

for thursday june 23, 2011 ← prev ( 5 )

Cosmic Encounter® Online at Facebook illustration

All Time Top Bot Aliens

SQL

select t.ce_text, sum(ar_bot_mrics) 'total'
from alien a inner join alien_rank ar on a.alien_code = ar.ar_alien_code
inner join ce_text t on a.alien_name_id = t.ce_text_id
group by t.ce_text order by sum(ar_bot_mrics) desc limit 10;

Results (as of June 22, 2011)

Rank	Alien	M-rics
.......................................................
1	Pacifist	181,136
2	Empath	172,218
3	Macron	168,023
4	Oracle	165,003
5	Clone	162,853
6	Virus	161,977
7	Trader	159,244
8	Vulch	157,798
9	Sorcerer	156,687
10	Filch	149,588

Thanks. — Bill Eberle (for Cosmic)

for thursday june 23, 2011 ← prev ( 5 )

Cosmic Encounter® Online at Facebook illustration

events prev/first next/last tech tantra

just thinking . . . for fun