22 101 10/10/96 58 103 11/12/96 - - PDF document

22 101 10 10 96 58 103 11 12 96
SMART_READER_LITE
LIVE PREVIEW

22 101 10/10/96 58 103 11/12/96 - - PDF document

sid bid day 22 101 10/10/96 58 103 11/12/96 sid sname rating age


slide-1
SLIDE 1
  • sid

sname rating age 22 dustin 7 45.0 31 lubber 8 55.5 58 rusty 10 35.0 sid sname rating age 28 yuppy 9 35.0 31 lubber 8 55.5 44 guppy 5 35.0 58 rusty 10 35.0

sid bid day 22 101 10/10/96 58 103 11/12/96

  • !

" #$

%!!

" !!&

  • ' ! ($

!)

' ! ! * $ (' '

' !) '+,+,-

%-%+*- $

$! $ .

/0/*-1%-%+*-2 3,

  • 4//

< > = ≤ ≥ ≠ , , , , ,

  • 5
  • !607! !

! $" 8

* $ 9$ ! $ !! %!%-%+*- $!$

  • $ !!

$7.' $:! !! $

  • ;
  • /0/*-

3, " 4// < '+ <=

() ()

  • >

5;=

  • =

=?=?@A

  • >

5;= ;B = ??@A

  • B

;;;

  • =

=?=?@A

  • B

;;; ;B = ??@A ;B

  • =

;=

  • =

=?=?@A ;B

  • =

;= ;B = ??@A

  • A

!"#$

!

$$3, - $" 7 8

/0/*- 3, " 4// < '+ <= /0/*- 3, " 4// <" '+ <=

% %

  • &

,

slide-2
SLIDE 2
  • >

' (

%-%+*- 7

!!&

!! !$) )

/0/*- & %-%+*- " !7!!&

/0/*- 3, " 4// <

  • B
  • % !#$

$8'* + )

' ! 0%C/ ! DEF !

DGF ! =

  • /0/*- 9;H '

3, 4// 0%C/IJEGJF

  • @

'( (

  • K+%,+8*

$ ! ! $ ( " ! 607)

%!$, '+

!" &

' "8/L*/M-

( ! $K+%,+ /L*/M-&)

/0/*- 3, J J" 4// < '+ <J '+ (J <IF , J <IF) /0/*- 3, J J" 4// < '+ <J '+ J <IF K+%,+ /0/*- 3, J J" 4// < '+ <J '+ J <IF

  • =

'( (

  • %+-//*-8*

$ ! !$

* !

K+%,+ %+-//*-

7 " !!

/0/*- 3, J J"

J J"

4// <'+ <J '+<'+ <J '+ (J <IF '+ J <IF) /0/*- 3, J J" 4// < '+ <J '+ J <IF %+-//*- /0/*- 3, J J" 4// < '+ <J '+ J <IF

C!.

  • "

'"$ !! !6084//

! 607.(' 3, 4'N%+ )

  • ! F" "O=+,-%+
  • !7 !

" 8'%, )

/0/*- 3, 4// %+ (/0/*- 3, " 4// <=)

' (-./01

  • "

/L%- $ $ %+

%!K+%6K/ H$#)!

" ! O= (K+%6K/ ! $$PH " $H#)&)

%7 9

$! $

/0/*- 3, 4///L%- (/0/*- H 3, " 4// <='+ <)

' (-./01

slide-3
SLIDE 3
  • 23

F"%+/L%-K+%6K/*

+,-%++,-/L%-+,-K+%6K/

' "8 '+Q '00 %+ 3 !

4 8

> < = ≥ ≤ ≠ , , , , ,

/0/*- H 3, 4// R'+Q (/0/*- 3, 4// <I4 F)

  • 5

# "4#4 5"

/L*/M- 79+,-%+

  • ! ( F) ! F""

S$ ) ) /0/*- ( %+-//*- 7&)

'( (1

/0/*- 3, J J" 4// < '+ <J '+ J <IF '+ %+ (/0/*- 3, J J" 4// <'+ <J '+ J <IF)

  • ;

6

0F

/L*/M-8

/0/*- 3, 4//+,-/L%-

((/0/*- J

3,J J) /L*/M-

(/0/*-

3, " 4// <))

/0/*- 3, 4//+,-/L%-(/0/*- J 3, J J 4//+,-/L%-(/0/*- 3, " 4// <J '+<))

))) ))) # 3 F"" () ()

  • A

!3

!# ! *,K+- (H) *,K+- (1%-%+*-2') K (1%-%+*-2') 'N (1%-%+*-2') 'L (') %+ (') /0/*-'N() 3, 4// <= /0/*-*,K+-(H) 3, /0/*-'N(%-%+*-) 3, 4// <= /0/*- 3, 4// <(/0/*-'L() 3, )

  • /0/*-*,K+-(%-%+*- )

3, 4//<IJ F

  • >

'*+

  • !7.

(F ,KMJQ)

  • 7

7" 7 60?@ $$

/0/*- 'L () 3, /0/*- 3, 4// <

(/0/*-'L()

3, ) /0/*- 3, 4// (/0/*-'L() 3, )

<

  • B

27

!F"$$ $

(7!)$ $$ !" !$

* 8'

)

% F "

#"! ".

$$ " ! =P

=7 (.)8 /0/*-%+() 3, 4// < 3 <=8

slide-4
SLIDE 4
  • @

87#359:;!$"7

  • () ()

$ (%+()))

  • () !

%"$ $ % ""$ $(' !$ ""! )

/0/*-1%-%+*-2 3,

  • 4//

,KMJQ 4'N%+

  • =
  • 9$ ! $$

! D( ! $ $ $" !

  • $$

$/#$ ".

%!!

! $ $$ (60 #$ $.)

,$ $7! $

  • ' <=

.>%

  • ' .>%

?

/0/*- %+ () ' 3, 4// R<B ,KMJQ 4'N%+ *,K+- (H)R sid sname rating age 22 dustin 7 45.0 29 brutus 1 33.0 31 lubber 8 55.5 32 andy 8 25.5 58 rusty 10 35.0 64 horatio 7 35.0 71 zorba 10 16.0 74 horatio 9 35.0 85 art 3 25.5 95 bob 3 63.5 96 frodo 3 25.5

! 1

1

rating minage 3 25.5 7 35.0 8 25.5

  • 5

' .>% ? )

rating age 7 45.0 1 33.0 8 55.5 8 25.5 10 35.0 7 35.0 10 16.0 9 35.0 3 25.5 3 63.5 3 25.5

rating minage 3 25.5 7 35.0 8 25.5 rating age 1 33.0 3 25.5 3 63.5 3 25.5 7 45.0 7 35.0 8 55.5 8 25.5 9 35.0 10 35.0

slide-5
SLIDE 5
  • ;

' .>% ? @/)

rating age 7 45.0 1 33.0 8 55.5 8 25.5 10 35.0 7 35.0 10 16.0 9 35.0 3 25.5 3 63.5 3 25.5

rating age 1 33.0 3 25.5 3 63.5 3 25.5 7 45.0 7 35.0 8 55.5 8 25.5 9 35.0 10 35.0 rating minage 7 35.0 8 25.5

HAVING COUNT (*) > 1 AND EVERY (S.age <=60) What is the result of changing EVERY to ANY?

  • A

' .>% ? .>@/)

/0/*- %+ () ' 3, 4// R<B'+ T<A= ,KMJQ 4'N%+ *,K+- (H)R sid sname rating age 22 dustin 7 45.0 29 brutus 1 33.0 31 lubber 8 55.5 32 andy 8 25.5 58 rusty 10 35.0 64 horatio 7 35.0 71 zorba 10 16.0 74 horatio 9 35.0 85 art 3 25.5 95 bob 3 63.5 96 frodo 3 25.5

! 1

1

rating minage 3 25.5 7 35.0 8 25.5

  • >

'%

  • $ "S !

! ")=A(

! 4//4'N%+ &

! $

" "&

/0/*- J*,K+- (H)' 3, J J" 4// < '+ <J '+ J <IF ,KMJQJ

  • B

' <.>% ?*+

4'N%+ 7 * $7

"B.

!4'N%+ $8

4'N%+*,K+-(H)R

/0/*- %+ () 3, 4// RB ,KMJQ 4'N%+ * (H)R

  • @

' <.>% ?*+

4'N%+ 7 * $7

"B.

!4'N%+ $8

4'N%+*,K+-(H)R

/0/*- %+ () 3, 4// RB ,KMJQ 4'N%+ T(/0/*-*,K+-(H) 3, 4// <)

  • =

'

  • ' $ .,+8

/0/*- 3, 4// <(/0/*-%+('N ())3, ) /0/*- -$-$" 3, (/0/*- 'N ()' " 3, ,KMJQ)' -$ 4// -$" <(/0/*-%+(-$") 3, -$) * (60?@)8

slide-6
SLIDE 6
  • "$

3"$ , (

) ( $ F)

60$ "$" !

  • $ ! $/8

$ $ !"? %<> ! 7 &

'+,+,- "&

9" (!, ) ! !!(

4// F" )

+ $ ($B)$ ?