Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- innocent_townsfolk,
- time_thing,
- innocent_townsfolk / time_thing as oh_the_humanity
- from (
- select
- count(*) as innocent_townsfolk,
- floor(exp(floor(ln((unix_timestamp(now()) - last_updated))))) as time_thing
- from
- kraken
- group by
- time_thing
- ) a
Add Comment
Please, Sign In to add comment