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
170
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
98
Research Computing Taxonomy
christinalk
0
200
HTCondor User Tutorial
christinalk
0
300
Other Decks in Programming
See All in Programming
20250708_JAWS_opscdk
takuyay0ne
2
140
構造化・自動化・ガードレール - Vibe Coding実践記 -
tonegawa07
0
120
ソフトウェア品質を数字で捉える技術。事業成長を支えるシステム品質の マネジメント
takuya542
2
16k
おやつのお供はお決まりですか?@WWDC25 Recap -Japan-\(region).swift
shingangan
0
150
テスターからテストエンジニアへ ~新米テストエンジニアが歩んだ9ヶ月振り返り~
non0113
2
230
「App Intent」よくわからんけどすごい!
rinngo0302
1
120
状態遷移図を書こう / Sequence Chart vs State Diagram
orgachem
PRO
2
230
レベル1の開発生産性向上に取り組む − 日々の作業の効率化・自動化を通じた改善活動
kesoji
1
330
20250704_教育事業におけるアジャイルなデータ基盤構築
hanon52_
5
1.2k
iOS 26にアップデートすると実機でのHot Reloadができない?
umigishiaoi
0
140
猫と暮らす Google Nest Cam生活🐈 / WebRTC with Google Nest Cam
yutailang0119
0
180
フロントエンドのパフォーマンスチューニング
koukimiura
6
2.2k
Featured
See All Featured
Understanding Cognitive Biases in Performance Measurement
bluesmoon
29
1.8k
Bash Introduction
62gerente
613
210k
Large-scale JavaScript Application Architecture
addyosmani
512
110k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
130
19k
GitHub's CSS Performance
jonrohan
1031
460k
Rebuilding a faster, lazier Slack
samanthasiow
83
9.1k
Music & Morning Musume
bryan
46
6.7k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
331
22k
Adopting Sorbet at Scale
ufuk
77
9.5k
Navigating Team Friction
lara
187
15k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
60k
The Cult of Friendly URLs
andyhume
79
6.5k
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