Window Frame UNBOUNDED?!

UNBOUNDED PRECEDING means ALL previous rows! UNBOUNDED FOLLOWING means ALL future rows. This creates running totals across the entire window!

#sql #sqltricks #unbounded #preceding #following #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #windowframes #advancedsql

https://www.youtube.com/watch?v=jkrzi1EItBg

Bitcoin vs. Political Power: The Cryptocurrency Revolution - Stefan Molyneux at TNW Conference

Historically, politicians have always fought for the power to create money out of thin air, so they can increase their spending without having to directly increase taxes. The staggering growth of political power throughout the twentieth century -- the century of war -- was largely made possible by replacing money limited by gold with paper currencies, which can be printed at will by government-controlled banks. Cryptocurrencies are the first self-limiting monetary systems in the history of mankind, and could be our greatest chance to check the growth of political power since the Magna Carta. Join Stefan Molyneux, the host of Freedomain Radio - the most popular philosophy show in the world - as he reveals the hidden political and military power of government currencies, and shows how cryptocurrencies could be greatest revolution in human history, and the foundation of a truly free and prosperous planet. The Next Web Europe Conference - April 25th, 2014 Freedomain Radio is 100% funded by viewers like you. Please support the show by signing up for a monthly subscription or making a one time donation at: http://www.fdrurl.com/donate Bitcoin Address: 1Fd8RuZqJNG4v56rPD1v6rgYptwnHeJRWs Litecoin Address: Lbxr3M8oezWaguEBc35MoyvQT88C85Sqpi Get more from Stefan Molyneux and Freedomain Radio including books, podcasts and other info at: http://www.freedomainradio.com (Published on Apr 25, 2014)

altCensored.com

#letsroll

⚃ ⚂ ⚂ ⚁ ⚁→#overstep
⚅ ⚀ ⚅ ⚀ ⚀→#tag
⚀ ⚂ ⚁ ⚂ ⚄→#banknote
⚃ ⚀ ⚅ ⚁ ⚃→#myspace
⚅ ⚄ ⚀ ⚂ ⚅→#unwed
⚅ ⚂ ⚂ ⚁ ⚃→#unbounded

overstep-tag-banknote-myspace-unwed-unbounded

Roll your own @ https://www.eff.org/deeplinks/2016/07/new-wordlists-random-passphrases

EFF's New Wordlists for Random Passphrases

Joe Bonneau dives deep into systems using dice to generate random passphrases and introduces EFF's three new wordlists.

Electronic Frontier Foundation

#letsroll

⚂ ⚂ ⚄ ⚂ ⚂→#hatbox
⚃ ⚃ ⚄ ⚂ ⚅→#pod
⚄ ⚁ ⚃ ⚄ ⚁→#ruined
⚁ ⚀ ⚁ ⚅ ⚀→#craftwork
⚅ ⚀ ⚀ ⚃ ⚁→#subsector
⚅ ⚂ ⚂ ⚁ ⚃→#unbounded

hatbox-pod-ruined-craftwork-subsector-unbounded

Roll your own @ https://www.eff.org/deeplinks/2016/07/new-wordlists-random-passphrases

EFF's New Wordlists for Random Passphrases

Joe Bonneau dives deep into systems using dice to generate random passphrases and introduces EFF's three new wordlists.

Electronic Frontier Foundation

#letsroll

⚂ ⚅ ⚃ ⚁ ⚂→#macaw
⚅ ⚀ ⚄ ⚅ ⚁→#tactics
⚅ ⚂ ⚂ ⚁ ⚃→#unbounded
⚀ ⚅ ⚂ ⚁ ⚂→#coliseum
⚀ ⚄ ⚅ ⚀ ⚃→#cider
⚀ ⚀ ⚀ ⚃ ⚀→#absinthe

macaw-tactics-unbounded-coliseum-cider-absinthe

Roll your own @ https://www.eff.org/deeplinks/2016/07/new-wordlists-random-passphrases

EFF's New Wordlists for Random Passphrases

Joe Bonneau dives deep into systems using dice to generate random passphrases and introduces EFF's three new wordlists.

Electronic Frontier Foundation

#letsroll

⚅ ⚁ ⚃ ⚀ ⚃→#tracing
⚅ ⚂ ⚂ ⚁ ⚃→#unbounded
⚄ ⚄ ⚁ ⚅ ⚁→#snoring
⚁ ⚅ ⚄ ⚀ ⚅→#feisty
⚁ ⚅ ⚀ ⚅ ⚅→#exfoliate
⚂ ⚃ ⚄ ⚂ ⚅→#impromptu

tracing-unbounded-snoring-feisty-exfoliate-impromptu

Roll your own @ https://www.eff.org/deeplinks/2016/07/new-wordlists-random-passphrases

EFF's New Wordlists for Random Passphrases

Joe Bonneau dives deep into systems using dice to generate random passphrases and introduces EFF's three new wordlists.

Electronic Frontier Foundation

#letsroll

⚅ ⚂ ⚂ ⚁ ⚃→#unbounded
⚁ ⚀ ⚅ ⚀ ⚅→#curator
⚀ ⚀ ⚀ ⚀ ⚅→#ability
⚃ ⚂ ⚁ ⚀ ⚂→#overgrown
⚃ ⚅ ⚄ ⚁ ⚃→#rebound
⚀ ⚀ ⚃ ⚄ ⚅→#aluminum

unbounded-curator-ability-overgrown-rebound-aluminum

Roll your own @ https://www.eff.org/deeplinks/2016/07/new-wordlists-random-passphrases

EFF's New Wordlists for Random Passphrases

Joe Bonneau dives deep into systems using dice to generate random passphrases and introduces EFF's three new wordlists.

Electronic Frontier Foundation

#letsroll

⚀ ⚃ ⚀ ⚁ ⚅→#breeches
⚀ ⚅ ⚃ ⚃ ⚀→#composite
⚃ ⚀ ⚁ ⚄ ⚄→#monogamy
⚄ ⚁ ⚃ ⚃ ⚂→#rubdown
⚂ ⚄ ⚄ ⚀ ⚄→#lagoon
⚅ ⚂ ⚂ ⚁ ⚃→#unbounded

breeches-composite-monogamy-rubdown-lagoon-unbounded

Roll your own @ https://www.eff.org/deeplinks/2016/07/new-wordlists-random-passphrases

EFF's New Wordlists for Random Passphrases

Joe Bonneau dives deep into systems using dice to generate random passphrases and introduces EFF's three new wordlists.

Electronic Frontier Foundation

#letsroll

⚁ ⚅ ⚁ ⚅ ⚂→#exporter
⚅ ⚂ ⚂ ⚁ ⚃→#unbounded
⚅ ⚂ ⚁ ⚁ ⚂→#twisty
⚀ ⚃ ⚄ ⚅ ⚅→#capable
⚅ ⚄ ⚄ ⚃ ⚂→#vibes
⚄ ⚃ ⚂ ⚅ ⚅→#simplify

exporter-unbounded-twisty-capable-vibes-simplify

Roll your own @ https://www.eff.org/deeplinks/2016/07/new-wordlists-random-passphrases

EFF's New Wordlists for Random Passphrases

Joe Bonneau dives deep into systems using dice to generate random passphrases and introduces EFF's three new wordlists.

Electronic Frontier Foundation

#letsroll

⚅ ⚃ ⚀ ⚅ ⚅→#unjustly
⚄ ⚂ ⚃ ⚂ ⚀→#sector
⚅ ⚂ ⚂ ⚁ ⚃→#unbounded
⚃ ⚅ ⚅ ⚅ ⚃→#reflux
⚅ ⚃ ⚄ ⚄ ⚀→#unsorted
⚂ ⚀ ⚂ ⚂ ⚂→#footing

unjustly-sector-unbounded-reflux-unsorted-footing

Roll your own @ https://www.eff.org/deeplinks/2016/07/new-wordlists-random-passphrases

EFF's New Wordlists for Random Passphrases

Joe Bonneau dives deep into systems using dice to generate random passphrases and introduces EFF's three new wordlists.

Electronic Frontier Foundation