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
640
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.3k
The Office Hours Data Conundrum
christinalk
0
170
A Different Kind of Carpentry
christinalk
0
170
Best Practices For All
christinalk
0
140
Workshop Development en breve
christinalk
0
88
Software Portability
christinalk
0
290
Software Licenses and Interpreted Languages
christinalk
0
110
Research Computing Taxonomy
christinalk
0
210
HTCondor User Tutorial
christinalk
0
300
Other Decks in Programming
See All in Programming
組込みだけじゃない!TinyGo で始める無料クラウド開発入門
otakakot
1
340
なぜあの開発者はDevRelに伴走し続けるのか / Why Does That Developer Keep Running Alongside DevRel?
nrslib
3
410
SODA - FACT BOOK(JP)
sodainc
1
8.5k
Catch Up: Go Style Guide Update
andpad
0
240
ALL CODE BASE ARE BELONG TO STUDY
uzulla
25
6.5k
Developer Joy - The New Paradigm
hollycummins
1
280
CSC509 Lecture 08
javiergs
PRO
0
220
CSC509 Lecture 05
javiergs
PRO
0
310
実践Claude Code:20の失敗から学ぶAIペアプログラミング
takedatakashi
15
6.3k
品質ワークショップをやってみた
nealle
0
580
スマホから Youtube Shortsを見られないようにする
lemolatoon
27
33k
あなたとKaigi on Rails / Kaigi on Rails + You
shimoju
0
170
Featured
See All Featured
Context Engineering - Making Every Token Count
addyosmani
7
270
Scaling GitHub
holman
463
140k
Documentation Writing (for coders)
carmenintech
75
5.1k
Building a Scalable Design System with Sketch
lauravandoore
463
33k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
190
55k
A designer walks into a library…
pauljervisheath
209
24k
Six Lessons from altMBA
skipperchong
29
4k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
333
22k
Testing 201, or: Great Expectations
jmmastey
45
7.7k
Imperfection Machines: The Place of Print at Facebook
scottboms
269
13k
Unsuck your backbone
ammeep
671
58k
Leading Effective Engineering Teams in the AI Era
addyosmani
7
510
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