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
580
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
130
A Different Kind of Carpentry
christinalk
0
130
Best Practices For All
christinalk
0
130
Workshop Development en breve
christinalk
0
72
Software Portability
christinalk
0
230
Software Licenses and Interpreted Languages
christinalk
0
83
Research Computing Taxonomy
christinalk
0
160
HTCondor User Tutorial
christinalk
0
250
Other Decks in Programming
See All in Programming
エンジニア1年目で複雑なコードの改善に取り組んだ話
mtnmr
3
2k
仮想ファイルシステムを導入して開発環境のストレージ課題を解消する
segadevtech
2
550
REXML改善のその後
naitoh
0
190
ドメイン駆動設計を実践するために必要なもの
bikisuke
4
330
Scala アプリケーションのビルドを改善してデプロイ時間を 1/4 にした話 | How I improved the build of my Scala application and reduced deployment time by 4x
nomadblacky
1
180
XStateでReactに秩序を与えたい
gizm000
0
730
私のEbitengineの第一歩
qt_luigi
0
450
o1モデルのプロンプトエンジニアリングって?
ktc_wada
0
270
長期運用プロダクトの開発速度を維持し続けるためのリファクタリング実践例
wataruss
8
2.7k
LangGraphでのHuman-in-the-Loopの実装
os1ma
3
1.1k
Modular Monolith Go Server with GraphQL Federation + gRPC
110y
1
580
Desafios e Lições Aprendidas na Migração de Monólitos para Microsserviços em Java
jessilyneh
2
150
Featured
See All Featured
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
1
54
We Have a Design System, Now What?
morganepeng
48
7.1k
The Pragmatic Product Professional
lauravandoore
31
6.2k
A designer walks into a library…
pauljervisheath
201
24k
KATA
mclloyd
27
13k
Gamification - CAS2011
davidbonilla
79
5k
Fontdeck: Realign not Redesign
paulrobertlloyd
80
5.1k
What's in a price? How to price your products and services
michaelherold
242
11k
Build your cross-platform service in a week with App Engine
jlugia
228
18k
Making the Leap to Tech Lead
cromwellryan
128
8.8k
Being A Developer After 40
akosma
84
590k
GraphQLの誤解/rethinking-graphql
sonatard
65
9.8k
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