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
600
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
140
A Different Kind of Carpentry
christinalk
0
140
Best Practices For All
christinalk
0
130
Workshop Development en breve
christinalk
0
74
Software Portability
christinalk
0
240
Software Licenses and Interpreted Languages
christinalk
0
86
Research Computing Taxonomy
christinalk
0
170
HTCondor User Tutorial
christinalk
0
260
Other Decks in Programming
See All in Programming
testcontainers のススメ
sgash708
1
120
「とりあえず動く」コードはよい、「読みやすい」コードはもっとよい / Code that 'just works' is good, but code that is 'readable' is even better.
mkmk884
3
490
Kaigi on Railsに初参加したら、その日にLT登壇が決定した件について
tama50505
0
100
Fibonacci Function Gallery - Part 1
philipschwarz
PRO
0
220
たのしいparse.y
ydah
3
120
競技プログラミングへのお誘い@阪大BOOSTセミナー
kotamanegi
0
360
情報漏洩させないための設計
kubotak
3
310
선언형 UI에서의 상태관리
l2hyunwoo
0
180
良いユニットテストを書こう
mototakatsu
8
2.7k
短期間での新規プロダクト開発における「コスパの良い」Goのテスト戦略」 / kamakura.go
n3xem
2
170
数十万行のプロジェクトを Scala 2から3に完全移行した
xuwei_k
0
280
ゆるやかにgolangci-lintのルールを強くする / Kyoto.go #56
utgwkk
2
390
Featured
See All Featured
Agile that works and the tools we love
rasmusluckow
328
21k
Keith and Marios Guide to Fast Websites
keithpitt
410
22k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.3k
Gamification - CAS2011
davidbonilla
80
5.1k
No one is an island. Learnings from fostering a developers community.
thoeni
19
3k
The Language of Interfaces
destraynor
154
24k
Fashionably flexible responsive web design (full day workshop)
malarkey
405
66k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
232
17k
Being A Developer After 40
akosma
87
590k
Rebuilding a faster, lazier Slack
samanthasiow
79
8.7k
Why You Should Never Use an ORM
jnunemaker
PRO
54
9.1k
Music & Morning Musume
bryan
46
6.2k
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