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
520
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
110
A Different Kind of Carpentry
christinalk
0
130
Best Practices For All
christinalk
0
120
Workshop Development en breve
christinalk
0
68
Software Portability
christinalk
0
190
Software Licenses and Interpreted Languages
christinalk
0
80
Research Computing Taxonomy
christinalk
0
140
HTCondor User Tutorial
christinalk
0
240
Other Decks in Programming
See All in Programming
コーンフレークから始める モデリング会話入門
ogurotakayuki
0
340
CA.swift19 恋するAIアプリ開発の裏側
oskmr
0
360
スクラムガイドのスプリントレトロスペクティブを改めて読みかえしてみた / Re-reading the Sprint Retrospective Section in the Scrum Guide
mackey0225
3
400
DMMプラットフォームがTiDB Cloudを採用した背景
pospome
8
3.9k
try! Swift Tokyo 2024のLT枠に採択されたプロポーザルを出すときに考えていたこと
ski
0
350
Build with AI 2024 Seoul - 제로부터 시작하는 Flutter with Gemini 생활 - 박제창
itsmedreamwalker
0
200
Ruby Pattern Matching
bkuhlmann
0
920
Git Lint
bkuhlmann
4
750
単体テストを書かない技術 #phpcon_odawara
o0h
PRO
26
8.1k
VS Code をプロダクトにどう取り込むか
onomax
1
340
Elm 0.19.0 Changes
bkuhlmann
0
490
Blue/Greenデプロイの導入による 運用フローの改善
kudoas
1
360
Featured
See All Featured
Six Lessons from altMBA
skipperchong
20
3k
Java REST API Framework Comparison - PWX 2021
mraible
PRO
18
6.9k
We Have a Design System, Now What?
morganepeng
42
6.7k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
77
42k
Building Effective Engineering Teams - LeadDev
addyosmani
28
1.8k
Being A Developer After 40
akosma
56
580k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
13
1.5k
Design by the Numbers
sachag
274
18k
Scaling GitHub
holman
457
140k
Large-scale JavaScript Application Architecture
addyosmani
504
110k
The MySQL Ecosystem @ GitHub 2015
samlambert
242
12k
Automating Front-end Workflow
addyosmani
1355
200k
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