Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
Query Live Database
Christina Koch
August 23, 2016
Programming
0
320
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
750
The Office Hours Data Conundrum
christinalk
0
62
A Different Kind of Carpentry
christinalk
0
98
Best Practices For All
christinalk
0
71
Workshop Development en breve
christinalk
0
47
Software Portability
christinalk
0
110
Software Licenses and Interpreted Languages
christinalk
0
56
Research Computing Taxonomy
christinalk
0
110
HTCondor User Tutorial
christinalk
0
190
Other Decks in Programming
See All in Programming
アジャイルで不確実性に向き合うための開発タスクの切り方
tanden
4
1.1k
How to Test Your Compose UI (Droidcon Berlin 2022)
stewemetal
1
130
Windows コンテナ Dojo 第5回 OpenShift で学ぶ Kubernetes 入門
oniak3ibm
PRO
0
130
このタイミングで知っておきたい 開発生産性の高いエンジニア組織の特徴とは / dev-sumi-20220721-productivity-features
findyinc
7
2.6k
ちょっとつよい足トラ
logilabo
0
350
ECサイトの脆弱性診断をいい感じにやりたい/OWASPKansaiNight_LT1_220727
owaspkansai
0
280
VIMRC 2022
achimnol
0
120
Untangling Coroutine Testing (Droidcon Berlin 2022)
zsmb
1
480
Getting Started With Data Structures
adoranwodo
1
260
読みやすいコード クラスメソッド 2022 年度新卒研修
januswel
0
2.9k
Isar勉強会
hoddy3190
0
340
ふんわり理解するcontext
rukiadia
1
180
Featured
See All Featured
Large-scale JavaScript Application Architecture
addyosmani
499
110k
Thoughts on Productivity
jonyablonski
44
2.4k
Building Flexible Design Systems
yeseniaperezcruz
310
34k
The Brand Is Dead. Long Live the Brand.
mthomps
46
2.7k
Become a Pro
speakerdeck
PRO
3
900
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
349
27k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
15
980
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
316
19k
Reflections from 52 weeks, 52 projects
jeffersonlam
337
17k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
107
16k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
29
4.4k
Robots, Beer and Maslow
schacon
152
7.1k
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