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
560
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.1k
The Office Hours Data Conundrum
christinalk
0
120
A Different Kind of Carpentry
christinalk
0
130
Best Practices For All
christinalk
0
130
Workshop Development en breve
christinalk
0
71
Software Portability
christinalk
0
210
Software Licenses and Interpreted Languages
christinalk
0
81
Research Computing Taxonomy
christinalk
0
150
HTCondor User Tutorial
christinalk
0
250
Other Decks in Programming
See All in Programming
OpenAI/Gemini APIを使って EPUBを翻訳するCLIツールをつくってみた
tomiyan
0
790
日付と正規化
megmogmog1965
0
140
ぼっちを避けて楽しむためのアノテコノテ / Various Tips and Tricks to Avoid Loneliness and Have Fun
nrslib
3
1.7k
英語
s_shimotori
1
220
入社1ヶ月でここまでやった!Findy Toolsインフラ支援の最適化
rvirus0817
6
1.4k
Cloudflare Workers x AWS Lambdaの組み合わせユースケース / Cloudflare Workers x AWS Lambda Combination Use Case
seike460
PRO
2
310
Rust.Nagoya #1
codemountains
0
170
ピグパーティにおけるMongoDB CommunityバージョンからAtlasへの移行事例
10969hotaka
0
130
DMMプラットフォームにおけるTiDBの導入から運用まで
pospome
7
3k
DDDを志して3年経ったら「DDDの皮を被ったクリーンアーキテクチャ」になった話【デブサミ2024夏】
texmeijin
1
620
How to use Macrobenchmark
veronikapj
0
160
CSC307 Lecture 12
javiergs
PRO
0
220
Featured
See All Featured
Typedesign – Prime Four
hannesfritz
37
2.2k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
18
1.2k
Art, The Web, and Tiny UX
lynnandtonic
291
20k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
90
47k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
121
18k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
155
14k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
149
45k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
44
4.7k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
224
21k
Building Flexible Design Systems
yeseniaperezcruz
323
37k
Designing on Purpose - Digital PM Summit 2013
jponch
113
6.6k
How To Stay Up To Date on Web Technology
chriscoyier
784
250k
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