2 03

% 4 , 2 5, 6 7 89 :
;, , 0 % <0 ' =

> 1 ?@A?BAC??@

! " ! " #
$ %

#&
"
' # "
(
")
*
)" +,*-+, " ),
. )% '/
&*0 ".
1
# & #" * % "

! " # $ # $ % & $
$ $
SELE CT%

' SELE CT

$ # %

' '() $ *

+ # % '
SELE CT%

SELE CT ,

' '()
-./! 0
1
 23'.'
4./5&67
389014
/. '. 67
20)3 /21'.8((' /&)0
/1

+ SELE CT ,

' '(): -./! ;

(
SELE CT ALL
%

' $ +,

' '()8 : -./! ;

' '()< ; =%: -./! ;

' %

# ,

' '()0 ( <1 ( = -./! (

# <=%

) SELE CT -./!
%

FROM
# # ,

' '()- %0 ( 1
-./! ( -
23'.'- %0 ( > (0 %0 (

( FROM # %
8 *
+ + ! 8
! ? 68 '
'+ + %

& + $ IN
-./! INTO
+ % $ IN
+ $%

) IN +
+ %

+ ! 8 ,

' '(): -./! ( 0

1 DD<(,@
! @1 % =
' '(): -./! ( 0
1 D(,@! @
1 % D

+ ,

' '(): 0
1)/ (0 1 DD<)'B)C 8)868 '>(,@
A+0 ! = -./! (
' '(): 0
1)/ (0 1 D(,@
A+0 ! @
DD)'B)C
D -./! (

( +
( %

( # +
IN
%

( # SELE CT
#
%
AS
%

' $ <1 = 1 ,

' '()1 8 <1 = -./! '

( #
# %

SELE CT *
# %
5 SELE CT #
%
+ %

' $ ALL
% 8
# # $ SELE CT%

! " ! " #

! DIST INCT $
%

& -
% $ #
- %

$
,

' '() 0 )0
1()<0 ( = -./! -

* DIST INCT +
% &
$ %

&
%
#
$
+ #
- # #
,

' '() 0 )0
1()0 ( <- - = -./! -

' %
DIST INCT $ . *
$ # $ %

8 DIST INCT DIST INCT ROW

#

& *
( #-
0( ,

' '() 0 )0
1()./2 ( %1 ( %0 (
-./! (
011'. ?
/01- /1 ( %0 ( >- %0 (

DIST INCT ROW -

% DIST INCT ROW
$ $ #
%
%
 $ %

TOP $
ORDE R BY% ORDE R BY

WHER E%

EF # ,

' '())/&EF: -./! - /. '. 67<) - = '(

' TOP % EF # EE
EE %

ORDE R BY PERC ENT%

( EF # EF
# ,

' '())/&EF&'.('1): -./! - /. '. 67<) - = '(

8
$ %8

& +
# ,

1 + ! %
*
%

&
! #
- %

8 # # # 0
'!&.'"
$ ' 5 G GH "
! ? %8
A" #
%

EI $ JFFK ' H -
8 ,

' '(): -./! - 23'.'<- - = > ALG

EIG
FKA

$ ! 9 6 *
! 0 ! 2 M%
 ' 5 ,

' '(): -./! - 23'.'<- - => 9 D

LGEIG
FKD
"

7 ' H $ + ,

' '(): -./! - 23'.'<- - => 9 D

EIG
LGFKD
"

EI $
JFFK% ( ,

ALG
EIG
FKA ALNEINFKA
AEIG
LGJFFKA E AEINLNJFFKA
ALG
EIG
JFFKA ALNEINJFFKA
AJFFKG
LGEIA AJFFKNLNEIA
AFLG
EIG
FKA AFLNEINFKA
AEIG
FLG
JFFKA E AEINFLNJFFKA
AFLG
EIG
JFFKA AFLNEINJFFKA
AJFFKG
FLG
EIA AJFFKNFLNEIA

E' $ # EJC
? %

9 $
' 5 ,A G G H A AFLG
EIG
FKA"%

#&

WHER E $ * FROM
# SELE CT%
WHER E + %

FROM # # WHER E JOIN

% ) *
JOIN WHER E $
$ %

WHER E * FROM
# ,

' '(): -./! ' 23'.' >D

9 D

# JF#LF H

' '(): -./! ' 23'.'' 6')2''1 JF81 LF

( + $ % '
! ? , AND OR XOR EQV IMP IS #NOT% 8 +
 + ,

O + EP O + JP

+ #
$ ,

F GH F CH
9 81 - -
9 81 9 9
- 81 9 -
- 81 - -
9 /. - 9
9 /. 9 9
- /. 9 9
- /. - -
9 B/. 9 -
9 B/. - 9
- B/. 9 9
- B/. - -
9 ' 9 9 9
9 ' 9 - -
- ' 9 9 -
- ' 9 - 9
9 0
!& 9 9
9 0
!& - -
9 0
!& 1 1
- 0
!& 9 9
- 0
!& - 9
- 0 1 9
1 0
!& 9 9
1 0
!& - 1
1 0
!& 1 1

NOT
NOT%

' IS % ' 9
,

O/ P 0 O/ P

8 +
%

# JF#LF H ,

' '(): -./! ' 23'.'' P EI81 ' O LE

 ' # E%FFFFF ,

' '(): -./! ' 23'.' ' P EI81 ' O LE" 81 P EFFF%FF

' '(): -./! ' 23'.'1/)' >D D

# * + EFFF # JFFF
! # * ,

' '(): -./! ' 23'.' P III%II81 O JFFF%FE" /. ( >D

! D81 ' >
D
( D
"

"

& $ IN
% + IN 9 C
- % + 0
1 ,

<1/)= 0
1 %%% "

& ! 6 #? * % &
,

' '(): -./! ' 23'.'& 0

1 D
! DD
6 DD
?* D
"

NOT IN%
,

' '(): -./! ' 23'.'& 1/)0

1 D
! DD
6 DD
?* D
"

' # "

$
BETW EEN # + ,

<1/)= 6')2''1 81

'
# % NOT
%
 ! ? #
+ BETW EEN 81 0 %'
$ / 6( #
%

8 * %

# LF#JF H ,

' '(): -./! ' 23'.'' 6')2''1 LF81 JF

' # E%FFF ,

' '(): -./! ' 23'.' ' 6')2''1 JF81 LF" 81 P EFFF%FF

# * + EFFF # JFFF
! # * ,

' '(): -./! ' 23'.' 6')2''1 EFFF%FF81 JFFF%FF" /. ( >D

! D81 ' >
D
( D
"

! ,

' '(): -./! ' 23'.'( >0

0- (& 6')2''1 JQFFF81 JQIII D
! DR
"

' LIKE $ +
% +
LIKE ,

0
S'

! % +
%

' ! ? 81 0#
! ? $ LIKE% ' 81 0#! ? + #
$ $ %

' $ $ $ ? K%+ #
! /' 6 ?
81 0
% $ 81 0 $ ! 8
8/ %
$ ? K%+ # ! /' 6 ? #
$ ! ? %

' ! ? 81 0NQI E
81 0 ! ? %8 $
! ? K%+ ! /' 6 ? + 81 0
NIJ
! ? $ ! /' 6 ? %
0 ! ? # #
 81 0
%

$ %'
$ LIKE
# +
,

I , 8 I *"

( V ; # "

( : U

( A

( * " < " =

( * " <# " =

' " < ="

+
81 0
* A" $ ? K%+ # ! /' 6
? %

8 "
N"% & D
< N$=D
# 8 #T%
% & D
< NTFNI=D
# * $
%

8NT FNEFF"% D
<8NT=D
D
<TN8=D
%

' < =" R

R"
+
NULL% ' IS NULL
%

8 + LIKE%
8 / # 8 / %1') $
! /' 6 ? # 81 0
,

' $ !,

' '(): -./! ' 23'.'8 0

S'D
!UD

# &# * (
#! ,

' '(): -./! ( 23'.'1 0

S'D
&<(N!=UD

# 8 ,

' '(): -./! ( 23'.'1 0

S'D
<8N =UD

' $ LIKE +
,
 ,
"
I *" I 8

9 DU D D: D D DD( DD
8 D D DD
( D

5 D<Y= D DY D D D

9 D UD D :D D DD H D D DD D

5 D; D DV D D DDL DD6 D D666 D

5 :" D<WN$= D DA D DF DDE DDJ D D DDEF D

. D
< N$=D DDDDD
ZDD
$D D
LDD
XDD D

- D
<WN$=D D
IDD
YDD
UD DDDDD
$DD
ID

D
<WFNI=D D
8DDDD
YDD
UD D
FDD
EDD
ID

( :" [ <W N =<WN$=D D<W N =AD D

8 IDD$FDDIID D DD FD

:" 8 $ * A"
! ? # $ ! 8
8/% $ 8 / ! /' 6 ? K%+
# 6 ( - 8 @3 ?
JKJ " # L * 81 0
* * % * <WN$=
+ +
* U XY %"%

")

5 NULL " % NULL

# + # % $ 9 6
" %
%

& $ IS NULL + %
$ +,

0 <1/)= 15

( &
,

' '(): -./! ( 23'.'( & 0 15

8H NOT IS NULL% '

( & ,

' '(): -./! ( 23'.'( & 0 1/)15

&
 FROM
% & $

)" +,*-+, " ),

' # $
SELE CT
SELE CT%

8 * $ % &
$ ( 0 %

)"

( % + ,

(/51) "

"%

COUN T + +
NULL # :" #
COUN T SELE CT #
NULL% 5 $
%

+ COUN T NULL%
NULL %
Y"%

8 $ COUN T%

' '()(/51) :" 8 <1\ ( = -./! (

' ! ,

' '()(/51) :" 8 <) . = -./! ( 23'.'( >D

! D

' ( & %' # ( &

NULL,

' '()(/51) ( & " -./! (

& ( #
) * #( & ,
 ' '()(/51) :" 8 <1\ ( = (/51) ) Y( & " -./! (

,*- , "

( + #
% + ,

!01 "
!8B "

$ % !

"% + # NULL
+ # %

8 $ MAX #MIN%

# ( ,

' '()!8B 0 ( "8 ! +0 -./! (

# # $ ,

' '()!8B ) "8 ! +- !0

1) "8 ! - -./! -

# ,

' '()!8B - 1 "8 ' ? !0

1- 1 "8 ' ! # -./! '

?* ,

' '()!0
1- 0 "8 9 -./! ' 23'.'( >D
?* D

),

% + ,

5! "

# + $
$ % +
"%
+ # NULL
%

8 + $ SUM%
 ,

' '() 5! ) "8 ) - -./! -

6 0
98 #) H ,

' '() 5! 6 " 8 ) 6 5! 098" 8 ) 0

98 5! 6 ]0
98" 8 ) -./! - 23'.'-
6')2''1 AFKG
FEG
JFFKA 81 AF^G
LFGJFFKA

. )% '/

GROU P BY
* %'
SELE CT SUM COUN T # +
% + GROU P BY ,

' '() -./! $ <23'.' = 4./5&67 %

. NULL +
NULL
# # %

+ WHER E% 5 $
HAVI NG %
HAVI NG *
WHER E%

#
4./5&67 #
SELE CT,

' '()0 ( ( :" 8 <1\ - = 5! ) "8 <0 ) = -./! - 4./5&670 (

8 $
H $ WHER E # *
,

' '()0 ( (/51) :" 8 <1\ - = 5! ) "8 <) - = -./! - 23'.'- 6')2''1
AFKGFEG
JFFKA 81 AF^GLFG JFFKA 4./5&670 (

8 # +
% $
$
%

& #
E%_FF ,

' '()0 ( (/51) :" 8 <1\ - = 5! ) " 8 <) - = -./! - 23'.'- 6')2''1
AFEGFEG
JFFKA 81 AFLGLEG JFFKA 4./5&670 ( 389014 5! ) " P> E_FF%FF
! GROU P BY FROM
! / /' # SELE CT
# %
SELE CT GROU P BY
$ %

&*0 ".

HAVI NG $ $ #
GROU P BY + ,

' '() -./! $ <23'.' = 4./5&67 % 3890

14 " >

HAVI NG WHER E $
# GROU P BY%

HAVI NG # KF + AND # OR%

GROU P BY #HAVI NG%

' '()(/51) 0 ' "8 ) ( -./! ' 4./5&67(

8 #
,

' '()(/51) 0 ' "8 ) ( -./! ' 4./5&67( 3890

14 ( >D
?* D

& % &
- #' ,

' '()(/51) 0 - " 8 <1\ - = ' %1 -./! - 0

11'. ?
/01' /1
- %0 ' >' %0 ' 4./5&671 3890
14 1 >D
' ! $D

5 $ $ $
% ORDE R BY
$
% + ORDE R BY ,

' '(): -./! /. '. 67 <8 (` ' (= < = <8 (` ' (=

' * ( ,
 ' '(): -./! ( /. '. 671 8 (

ASC #
ORDE R BY% ' TN8 INF"
DESC % (
NULL $ #
%

' *
%
SELE CT
C $ :"
FROM%

*
D
1 D
,

' '(): -./! ( /. '. 67J8 (

( /. '. 67
,

E% ORDE R BYC
J%
# %

' # + %
,

' '()0 ( 0- ) -./! - /. '. 670 ( ) '(

ORDE R BY # SELE CT #
TOP TOP n PERC ENT #
ORDE R BY #
H %

# & #" * % "

WITH OW NERA CCES S O PTIO N

#
+
&' ( )" $
%

' # SELE CT $
# $
SELE CT" SELE CT * INT O" + INSE RT I NTO" #
%

& #

$ #
# % ( WITH OW NERA CCES S
OPTI ON,

' % " ! ! 8
 !
,

"
( ;'

' '(): -./! ' 20

)3 /21'.8((' /&)0
/1

8 D
' D
8 /
,

. %/ R
( ;' R ( + / S# Z/ ( )
. %/ R ' '(): -./! ( ;' R ( + / S# Z/ ( )+

* ! !
%

( ! ?

# WITH OWN ERAC CESS OPT ION%

' SELE CT #
%

/ * ,

0 2 I

4 , 2 5, 6 < C??@

" *, ,
M # % 5
$ + %

) * M M %7 Z # %