QUERIES
FOR
A
LIVE
STUDENT
DB
used
in
conjunc+on
with
www.datacarpentry.org/sql-‐ecology-‐lesson/
Slide 2
Slide 2 text
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
Slide 3
Slide 3 text
No content
Slide 4
Slide 4 text
SELECT name
FROM students
Slide 5
Slide 5 text
select name,name
from StUdEnTs
Slide 6
Slide 6 text
SELECT name, height
FROM students
Slide 7
Slide 7 text
SELECT name,
height*2.54
FROM students
Slide 8
Slide 8 text
No content
Slide 9
Slide 9 text
SELECT name, dept
FROM students
WHERE height <= 66
Slide 10
Slide 10 text
SELECT name, dept
FROM students
WHERE DoC
IN (‘Dog’, ‘Cat’)
Slide 11
Slide 11 text
SELECT name,
height*2.54
FROM students
ORDER BY height
Slide 12
Slide 12 text
SELECT name,
height*2.54
FROM students
WHERE height >= 68
ORDER BY name DESC
Slide 13
Slide 13 text
No content
Slide 14
Slide 14 text
SELECT COUNT(*)
FROM students
Slide 15
Slide 15 text
SELECT COUNT(*)
FROM students
GROUP BY DoC
Slide 16
Slide 16 text
SELECT MAX(height),
MIN(height)
FROM students
GROUP BY DoC