Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Query Live Database
Search
Christina Koch
August 23, 2016
Programming
0
620
Query Live Database
Christina Koch
August 23, 2016
Tweet
Share
More Decks by Christina Koch
See All by Christina Koch
Data Carpentry SQL Introduction
christinalk
0
1.2k
The Office Hours Data Conundrum
christinalk
0
160
A Different Kind of Carpentry
christinalk
0
160
Best Practices For All
christinalk
0
130
Workshop Development en breve
christinalk
0
83
Software Portability
christinalk
0
280
Software Licenses and Interpreted Languages
christinalk
0
94
Research Computing Taxonomy
christinalk
0
200
HTCondor User Tutorial
christinalk
0
300
Other Decks in Programming
See All in Programming
イベントストーミングから始めるドメイン駆動設計
jgeem
4
810
RubyKaigiで得られる10の価値 〜Ruby話を聞くことだけが RubyKaigiじゃない〜
tomohiko9090
0
140
機械学習って何? 5分で解説頑張ってみる
kuroneko2828
0
200
ワンバイナリWebサービスのススメ
mackee
10
7.7k
Perlで痩せる
yuukis
1
680
ワイがおすすめする新潟の食 / 20250530phpconf-niigata-eve
kasacchiful
0
300
実はすごいスピードで進化しているCSS
hayato_yokoyama
0
110
関数型まつり2025登壇資料「関数プログラミングと再帰」
taisontsukada
2
790
実践ArchUnit ~実例による検証パターンの紹介~
ogiwarat
2
250
赤裸々に公開。 TSKaigiのオフシーズン
takezoux2
0
130
AWS CDKの推しポイント 〜CloudFormationと比較してみた〜
akihisaikeda
3
220
UPDATEがシステムを複雑にする? イミュータブルデータモデルのすすめ
shimomura
1
530
Featured
See All Featured
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
32
2.3k
A Modern Web Designer's Workflow
chriscoyier
693
190k
Adopting Sorbet at Scale
ufuk
77
9.4k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
657
60k
Rebuilding a faster, lazier Slack
samanthasiow
81
9k
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
14
1.5k
We Have a Design System, Now What?
morganepeng
52
7.6k
The Pragmatic Product Professional
lauravandoore
35
6.7k
How to Think Like a Performance Engineer
csswizardry
24
1.7k
Music & Morning Musume
bryan
46
6.6k
Into the Great Unknown - MozCon
thekraken
39
1.8k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
29
1.8k
Transcript
QUERIES FOR A LIVE STUDENT DB used in conjunc+on
with www.datacarpentry.org/sql-‐ecology-‐lesson/
Fill out your cards • Name: first name
• Height: in INCHES • Dept (department): close enough (just pick one if you don’t have a home department) • DoC (Dog or Cat): Dog, Cat, Both, Neither, or leave blank
None
SELECT name FROM students
select name,name from StUdEnTs
SELECT name, height FROM students
SELECT name, height*2.54 FROM students
None
SELECT name, dept FROM students WHERE height <= 66
SELECT name, dept FROM students WHERE DoC IN (‘Dog’,
‘Cat’)
SELECT name, height*2.54 FROM students ORDER BY height
SELECT name, height*2.54 FROM students WHERE height >= 68
ORDER BY name DESC
None
SELECT COUNT(*) FROM students
SELECT COUNT(*) FROM students GROUP BY DoC
SELECT MAX(height), MIN(height) FROM students GROUP BY DoC