chap5_singleSlides

chap5_singleSlides - sid bid day 22 101 10/10/96 58 103...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: sid bid day 22 101 10/10/96 58 103 11/12/96 ! " ! # ! % " # ! ! ! ! "& " $ " ! ! ! sid 22 31 58 sname rating age dustin 7 45.0 lubber 8 55.5 rusty 10 35.0 sid 28 31 44 58 sname rating age yuppy 9 35.0 lubber 8 55.5 guppy 5 35.0 rusty 10 35.0 010 . 450 0 2 % .% .3 , ! ' ! " ! ) ! " (' (! ! ! !' ,, ) ' ! ! + " ' ! " ! ! ', ! ! " - ,,, ,-. * % .% . , ! !! !! ! " / "! ! ! ! " ! 61 7 # !9 ! ! " " ! " ! " ! ! " 8 % % .% . " , " ! . ! " " 7 ! /' ! !! : " " " " ! ! # ! 010 . 450 0 ! ; # ', ;* < ) ( ) + + + + * * B B = = B B * < * < < < >< >< ( B B B + * * * ?* ?@ +< <<A * < * < * < * ?* ?@ *+A * ?* ?@ *+A * ?* ?@ *+A + * * * ?* ?@ +< <<A + * * * ?* ?@ +< <<A $% & ! ' " 4- #! 010 . 450 0 7 ! ; ! ! ', ! # ', ! . 8 "# # ( ;* < - 010 . 450 0 # ; ;* < # ) #" * 010 . 450 0 ! ; % .% . ! , # ! " " 7 + " " + % .% . ! , & " " 010 . # ! " ! " &! 7 & 010 . 450 0 * ; ! 9 + H ' + 1% I C0 JEGJF % #! ' 1% C0 ! " 8) ! ; #" ! " ! G DF ! $ ,! -! ! ! #" " " " ! ! + ! " DF E " <! ! ) *! #" * K,% 8 -, ! ! ( # 61 7 % " "# & ' !# ( ! ) - ! !! " ! " ! " ', 010 . 4! J! J # 50 0 ; ', ;J ' , (J ! ! ;I F J ! ! ;I - F ) ! 8 0L 0M. " ! 010 . 450 0 K,% -, 010 . 450 0 ! J! J F ; ', ' , J ! ! ;I ! J! J # ;J K,% -, 0L 0M.&) ; ', ' , J ! ! ;I # ;J F ) *! #" * 010 . 4- % ,.0 0 .8 ! ! " % ! ! K,% -, ! " 61?@ + ! !F ! ! " % ,.0 0. J* # * J! J+ # + ! 50 0 ;* ', * ;J* ! ', ;+ ', + ;J+ ' , (J* ! ! ;I F , J+ ! ! ;I ' 010 . 450 0 ! J! F ) C ! J! " J F / # ;J ; ', ' , J ! ! ;I 7 ! # ! ! " " % ,.0 0 . 010 . 4! J! J 50 0 ; ', ' , J ! ! ;I # ;J F % ) ! 010 . 450 0 #" * ! % ( 010 . , 450 0 /0 2 1 '# "" ! 618 " "! 61 7 / (' 5 'N% , ) .! " ! !# F # .! ! " # !8 ) " ! " ! # ;* ) < 50 0 ! O* < 7 + 4,-. % , ! " " ." % ) ! #" #" * /0 2 1 010 . 4! 5 0 0 0L% . ( 010 . H 450 0 # ;* ', < ; ) 0L% . ! % K,% " 6K0 ! 6K0 (K,% % ! " ! ! !! ! % , H &+ " !! # ! " ! O* ! < " ! P H ! ! #! H &+ &) 7 9 ! 3 F # 4 % 0L% . , K ,% 6K0 ,-. % ,-. 0L% . , ,-. K,% 6K0 ! ' !# 4 ! ! 8 ',Q '11 % , ,,,,, !! " ! 5! ! 8 010 . H 4! 50 0 R ',Q ( 010 . + 4! 50 0 + + ;I 5! !) F &# ) 010 . 450 0 % *! ! ; ', & #" * " 5 % J! # ', ;J ', J ! ! ;I F % ( 010 . + , 4! + J! J+ # + 50 0 + ;+ ', + ;J+ ', J+ ! ! ;I F ) J 0L 0M. 7 9 ,-. % , .! " ! 010 . (! F) ! "! !# F ! S + ( !% ,.0 0 . 7 # + &) (* ) 6 4 ! !# F # ! 1F! ! 0L 0M.8 (+ 010 . ) 010 . 4! 5 0 0 ,-. 0L% . (( 010 . J 4 - J! 0L 0M. ( 010 . 450 0 J) # ; )) 4! 5 0 0 ,-. 0L% . ( 010 . J 4J! J 50 0 ,-. 0L% . ( 010 . " " +++ 450 0 " # " +++ ', # ;J ; )) & "# $ " ! 010 . 4- 4 $ !! " - K,. (H) -K,. ( 2 % .% .3 , ') K ( 2 % .% .3 , ') 'N ( 2 % .% .3 , ') 'L (') % (') , -K,. (H) ! ) ;* < 010 . 'N ( 4! 50 0 010 . 450 0 010 . 450 0 ! ; ( 010 . 4'L( + ) ! + ) ) -K,. ( % .% . , ) ! ;I F J! 010 . 'N ( 4! 50 0 % .% . , ;* < ) . ( "7 F! ! ! !" / ! - KM JQ ) 010 . 4010 . 450 0 ,'L ( ) ! ! ; ( 010 . 'L ( + . 7 7# ! 7 ! 61?@ + ! ! ! ) ! 4010 . 4! 5 0 0 ( 010 . 4- ! + ) 'L ( + ) ! + ) ; 3 !7 !" F # (7 " ) ! ! !# " ! 8) " !" + % $ ! !F ! *7 < *8 < ! # # ! ! 010 . 450 0 ! " ! ! ! " ! ! ! ! # " # / ! "! * ! * P < (/)8 %( , ! ; ) 4! ; * + 8 "7&459 : 010 . 2 % .% .3 , 450 0 ! - KM JQ 5 'N% , ! ;$' %7 . . % ! ! () # () !( # ! " ) %(+ , ! " ! ! ! # ! # # " ! () )) (' . !9 ! ! " !! ! " ! D ! " ! ! / ! ! ! /) * " ! # ! 0$ . ! # %" " ! ! ! ! " ( 61 ! ! $! - 7 " ! ) ! !" " 010 . #" %( , ' #" =" ) sid 22 29 31 32 58 64 71 74 85 95 96 0 < 4! 50 0 R; * B -KM JQ 5 'N% , -K,. (H) R * $# rating 3 7 8 minage 25.5 35.0 25.5 sname rating dustin 7 brutus 1 lubber 8 andy 8 rusty 10 horatio 7 zorba 10 horatio 9 art 3 bob 3 frodo 3 age 45.0 33.0 55.5 25.5 35.0 35.0 16.0 35.0 25.5 63.5 25.5 ) ! rating 7 1 8 8 10 7 10 9 3 3 3 !" " age 45.0 33.0 55.5 25.5 35.0 35.0 16.0 35.0 25.5 63.5 25.5 #" rating 1 3 3 3 7 7 8 8 9 10 #" =" age 33.0 25.5 63.5 25.5 45.0 35.0 55.5 25.5 35.0 35.0 0 < + rating 3 7 8 minage 25.5 35.0 25.5 ) #" !" = " #" #" 0! < " >+ 1 HAVING COUNT (*) > 1 AND EVERY (S.age <=60) rating 7 1 8 8 10 7 10 9 3 3 3 age 45.0 33.0 55.5 25.5 35.0 35.0 16.0 35.0 25.5 63.5 25.5 rating 1 3 3 3 7 7 8 8 9 10 age 33.0 25.5 63.5 25.5 45.0 35.0 55.5 25.5 35.0 35.0 rating minage 7 35.0 8 25.5 What is the result of changing EVERY to ANY? ) " 010 . !" #" %( , ' #" = ) # 0! < 0 < >+ 1 sname rating dustin 7 brutus 1 lubber 8 andy 8 rusty 10 horatio 7 zorba 10 horatio 9 art 3 bob 3 frodo 3 age 45.0 33.0 55.5 25.5 35.0 35.0 16.0 35.0 25.5 63.5 25.5 sid 22 4! 50 0 R; * ', B T; A 29 < 31 -KM JQ 32 5 'N% , -K,. (H) R * 58 64 rating minage 71 3 25.5 74 $# 7 35.0 85 8 25.5 95 96 ) " ! !" - K,. (H) ' " ! # ;J ! 010 . J 4! 50 0 ; -KM JQ J J! J ', ', J ! ! ;I F ! ! "! " #! # ! # 50 0 S! !" " ! # ! ! & ! !& + ! ?@ * 5 'N% , ! ! ) ! !" " #" = #" A0 < ,! - 010 . %( , ) 4! 50 0 R* B -KM JQ 5 'N% , * T ( 010 . -K,. (H) 4!+ 50 0 ;+ ) ! ! ! 5 'N% , !! + 7 !! * # B/ 8 ! 7 "5 'N% , 5 'N% , -K,.(H) R* ) " ' " ! #" " " ! ! ! ! / -, 8 010 . 450 0 ; ( 010 . % ('N , (+ )) 4 - ! + ) ! ! !( . 61?@ )8 + # 'N ( )' . ; ( 010 . % (. , 4. ) # ) )' # 010 . . 4( 010 . 4! - KM JQ 50 0 . # % 4 ! ' # ! F ! # ! )! ) # " ! ! "# 7 ! ( ! .#( ( ! ! 61 . % ! A< ! ', ! " ! !" - ! ? ! 08 ! & ,-. ! 9# !! " 50 0 , ! !( #& " . #) " " ( !F # ! B )! ? ) , & '% ! " % ## ! ! ? )! # ? ! ! " #! ! ( %F ( ! ! ! T+ < <) ! ! 6 ' ! *8 ! " ! 84 " ! ! ! # ! " 7 K" ! % #! # 7 !$ ! ! 0'.0 .'J10 0'.0 .'J10 ! ( % ,.0 0 5 ' (* ) < % ,.0 0 0'1 ) M % ' Q C0Q ( 50 C ( R; * ', T; * ) < # 5 ' (* ) < % ,.0 0 '.0 ) M % ' Q C0Q ( -, . '% ,. ! % 5 0 C (D % F TR ( 010 . J 4J! J 50 0 J ; ( ))) 4 3 & % ! ! C0 1 1 0'.0 .'J10 ! ( % ,.0 0 5 ' (* ) < ' % ,.0 0 !/ 0'1 % "! ) M % ' Q C0Q ( 50 C ! J! " ( ( 010 . -K,. ( U ( 010 . -K,. (J / ' 0 .% -, )4 )4 - !) J! J) T * <) < ! ! ! !P 0'.0 ' 0 .% -, 50 C ( ( 010 . -K,. ( U ( 010 . -K,. (J )4 )4 - !) J! J) T * <) < . " . 8 ! ! 8 ! ) " ! J " 0# ( # ! !( ' !( ! ) ) , 0DDD 0'.0 . % 0 ! !K '4.0 % 0 . -, '% , 1040 0, % ,0 .'J10 , , 4- 0' 5 .'.0 0,. % 0. , % ,.- Q! !( 010 . 4- , !, 50 0 , T; * B ! ) 61 ! " ! ! $ 0# ! % ! ! ! 7 # ! ! ! "! P! P" ! $ ' 61 7 P ! # ! !!7 " " ! " ! ! " : 7 $ ! # !" !! ! : # ! " " ! , +- ,K11 " ! !" # ! ! 61 ! " !! " ! . ! ! ...
View Full Document

Ask a homework question - tutors are online