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
160
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
95
Research Computing Taxonomy
christinalk
0
200
HTCondor User Tutorial
christinalk
0
300
Other Decks in Programming
See All in Programming
iOSアプリ開発で 関数型プログラミングを実現する The Composable Architectureの紹介
yimajo
2
220
エラーって何種類あるの?
kajitack
5
320
Create a website using Spatial Web
akkeylab
0
310
Team operations that are not burdened by SRE
kazatohiei
1
260
Enterprise Web App. Development (2): Version Control Tool Training Ver. 5.1
knakagawa
1
120
High-Level Programming Languages in AI Era -Human Thought and Mind-
hayat01sh1da
PRO
0
570
Code as Context 〜 1にコードで 2にリンタ 34がなくて 5にルール? 〜
yodakeisuke
0
110
PHP 8.4の新機能「プロパティフック」から学ぶオブジェクト指向設計とリスコフの置換原則
kentaroutakeda
2
660
VS Code Update for GitHub Copilot
74th
1
460
すべてのコンテキストを、 ユーザー価値に変える
applism118
2
930
PicoRuby on Rails
makicamel
2
110
0626 Findy Product Manager LT Night_高田スライド_speaker deck用
mana_takada
0
110
Featured
See All Featured
GraphQLの誤解/rethinking-graphql
sonatard
71
11k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
26
2.9k
Embracing the Ebb and Flow
colly
86
4.7k
Facilitating Awesome Meetings
lara
54
6.4k
Become a Pro
speakerdeck
PRO
28
5.4k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
29
1.8k
Being A Developer After 40
akosma
90
590k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
29
9.5k
Designing for humans not robots
tammielis
253
25k
Keith and Marios Guide to Fast Websites
keithpitt
411
22k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
20
1.3k
Bash Introduction
62gerente
614
210k
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