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.2k
The Office Hours Data Conundrum
christinalk
0
130
A Different Kind of Carpentry
christinalk
0
140
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
Делим тесты между QA и разработчиком
mariyasaygina
0
500
CDKを活用した 大規模コンテナ移行 プロジェクトの紹介
yoyoyopg
0
240
データサイエンスのフルサイクル開発を実現する機械学習パイプライン
xcnkx
2
480
クラウドサービスの 利用コストを削減する技術 - 円安の真南風を感じて -
pyama86
3
240
AWS CDKを用いたセキュアなCI/CDパイプラインの構築 / Build a secure CI/CD pipeline using AWS CDK
seike460
PRO
3
570
型付きで行うVSCode拡張機能開発 / VSCode Meetup #31
mazrean
0
230
Kubernetes上でOracle_Databaseの運用を楽にするOraOperatorの紹介
nnaka2992
0
150
App Router 悲喜交々
quramy
7
370
M5Stackボードの選び方
tanakamasayuki
0
200
個人開発で使ってるやつを紹介する回
yohfee
1
670
RDBの世界をぬりかえていくモデルグラフDB〜truncus graphによるモデルファースト開発〜
jurabi
0
150
色んなオートローダーを覗き見る #phpcon_okinawa
o0h
PRO
5
370
Featured
See All Featured
Into the Great Unknown - MozCon
thekraken
30
1.4k
Put a Button on it: Removing Barriers to Going Fast.
kastner
58
3.5k
The Mythical Team-Month
searls
218
43k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
26
2k
Large-scale JavaScript Application Architecture
addyosmani
509
110k
Building a Scalable Design System with Sketch
lauravandoore
459
32k
Music & Morning Musume
bryan
46
6.1k
Atom: Resistance is Futile
akmur
261
25k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
355
29k
Why You Should Never Use an ORM
jnunemaker
PRO
53
9k
Code Review Best Practice
trishagee
62
16k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
26
1.3k
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