V PfdcK S
l CD B .) ,B 4 .) B B
l 4G 4 OR G .) aMN
, 4D D C
l eQ , 4 Rb , 4D D C aMN L
B D C
l
( G D B
l C 4 4 GB 4 C
4 D D B
l 4
Slide 21
Slide 21 text
)(
3
4
1 2
- 0
7
Slide 22
Slide 22 text
)(
2
l 0 7
- 1
l 0
43
l 2
Slide 23
Slide 23 text
:- 3 0 1
l 47 2 0
D
D
I
Slide 24
Slide 24 text
n
l o D1B
l l a
o
( ) ( B
R a
R i e
R B 1
Slide 25
Slide 25 text
)( (
Slide 26
Slide 26 text
C
) ( ) )
l
l L
) ) ) (/ (
l D
(/ (
l
Slide 27
Slide 27 text
E C
l E C L , ( R
l E C PS ), R
l E C IN R
l E C ( R
E C D
: A :
Slide 28
Slide 28 text
0/. -73394
l e atQ0/. qL QF d
S c i
l 6 ## 9 73394 2 :# # 1
l k 0/. s Q q
p ! !
! !
n o ! !
fhm
7 4l
belong_to organization employee
Slide 29
Slide 29 text
Slide 30
Slide 30 text
-
l
SELECT [] FROM [ ];
SELECT name FROM employee;
Slide 31
Slide 31 text
-
*
l *
SELECT * FROM employee;
Slide 32
Slide 32 text
-
l
SELECT [ 21 ] FROM [ 0 ] WHERE [];
SELECT * FROM employee WHERE joined_at >= '2010/1/1';
Slide 33
Slide 33 text
-
] a
l [ _
d
1 ./ 5 75 .7 :/05 6 /6 / :/ 276 1 5
joined_at > '2007/1/1' 726/. _ '
name = '' 6 5/ _ c e
id <> 10001 2. _
Slide 34
Slide 34 text
-
iNO f
( rL
) rL != ds
) nI K
)( ( c
, tvap
. ul moh q eT
./ . ul moh q eT
E6 < = > 5 : : 5 : : 6
Slide 35
Slide 35 text
name LIKE '%%';
%
' %
l
l
l
l
l
l
Slide 36
Slide 36 text
) )
( %
l name LIKE '%¥%%'
( '
Slide 37
Slide 37 text
-
l id IN (10001, 10003)
l
Slide 38
Slide 38 text
-
41
l
l
l 0 2 0
SELECT * FROM employee
WHERE
joined_at >= '2010/1/1' AND joined_at <= '2014/1/1';
Slide 39
Slide 39 text
1 1
Slide 40
Slide 40 text
-
D E
l E ) E
l AE E
l C C( E D
l
SELECT [ ] FROM [ ]
ORDER BY [
] [ASC/DESC];
SELECT * FROM employee ORDER BY joined_at ASC;
Slide 41
Slide 41 text
l
l 2
SELECT [ ] FROM [
ORDER BY [ ] [ASC/DESC] LIMIT [];
SELECT * FROM employee ORDER BY joined_at ASC LIMIT 2;
SELECT * FROM employee ORDER BY joined_at ASC LIMIT 1, 2;
Slide 42
Slide 42 text
#$
%
)
l "
!
SELECT [&'] FROM [(] GROUP BY [];
SELECT organization_id, COUNT(*) FROM belong_to
GROUP BY organization_id;
-
SELECT
organization.name, employee.name
FROM
belong_to
INNER JOIN organization
ON belong_to.organization_id = organization.id
INNER JOIN employee
ON belong_to.employee_id = employee.id;
Slide 57
Slide 57 text
Slide 58
Slide 58 text
-
(
"!&%$ ' %#&
l "!&%#&
l "!&%$ ' %#&
SELECT MAX(result) FROM grade;
SELECT AVG(result) FROM grade
WHERE result <> [];
Slide 59
Slide 59 text
-
1
SELECT AVG(result) FROM grade
WHERE result <> (SELECT MAX(result) FROM grade);
Slide 60
Slide 60 text
-
>
l <
l <
l <
SELECT class_id, MAX(result) FROM grade GROUP BY class_id;
SELECT class_id, AVG(result) FROM grade
WHERE
(class_id = 1 AND result <> [1
])
OR (class_id = 2 AND result <> [2
])
OR …
GROUP BY class_id;
Slide 61
Slide 61 text
-
1
1
SELECT class_id, AVG(result) FROM grade AS g1
WHERE
g1.result <> (
SELECT MAX(result) FROM grade AS g2
WHERE g1.class_id = g2.class_id
)
GROUP BY class_id;
Slide 62
Slide 62 text
SELECT class_id, AVG(result) FROM grade AS g1
WHERE []
GROUP BY class_id;
Slide 63
Slide 63 text
6 63 8 3 9 7 0
2 1 5 4
g1
SELECT class_id, AVG(result) FROM grade AS g1
WHERE []
GROUP BY class_id;
Slide 64
Slide 64 text
1
g1
WHERE
g1.result <> (
SELECT MAX(result) FROM grade AS g2
WHERE g1.class_id = g2.class_id
)
Slide 65
Slide 65 text
g1 g2
WHERE
g1.result <> (
SELECT MAX(result) FROM grade AS g2
WHERE g1.class_id = g2.class_id
)
Slide 66
Slide 66 text
.
g2
g1
WHERE
g1.result <> (
SELECT MAX(result) FROM grade AS g2
WHERE g1.class_id = g2.class_id
)
Slide 67
Slide 67 text
MAX(result)
g2
g1
WHERE
g1.result <> (
SELECT MAX(result) FROM grade AS g2
WHERE g1.class_id = g2.class_id
)