An SQL question
Posted in 1997
Hi everybody, can anyone help me with the attached question? Thanks in advance. begin 600 SQL question.doc MT,\\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````! M````"@``````````$ ``$0````$```#^____``````L```#_____________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M______________________]2`&\\`;P!T`" `10!N`'0`<@!Y```````````` M``````$````"````( ````(```````````````,```# #$ `%@`%`?______ M____`0``````````````````````````````8#.LGRT<O &@2>R?+1R\\`0X` M``! !P``, 0``%<`;P!R`&0`1 !O`&,`=0!M`&4`;@!T````````````____ M_P``````````=@(``````````````0````(````:``(!`@````,```#_____ M`P```-@,0 #.!P````````````#__P``````````````````!P````H8```\\ MBD<`3P!B`&H`90!C`'0`4 !O`&\\`; `````````````````*```````````` M`````````````@0`9 `8`````````!8``0'__________P4````````````` M`````````````````$#'L)\\M'+P!0,>PGRT<O $````````````````%`%,` M=0!M`&T`80!R`'D`20!N`&8`;P!R`&T`80!T`&D`;P!N```````````````` M````````````````````* `"`?____\\$````_____P`````````````````` M``````````````````````````````0```#4`0````````P```#]____`P`` M``0````%````!@```/[___\\(````"0```#@```#__________Q@```#^____ M#P```!H```#__________________________________________QD```#^ M____*0```!P````=````'@```!\\````@````(0```"(````C````) ```"4` M```F````)P```"@```#^_____O___RL````L````+0```"X````O````, `` M`#$````R````,P```#0````U````-@```#<```#^____.0```#H````[```` M/ ````(```#_________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M________20<``$P'``!-!P``3P<``%$'``!7!P``6@<``%L'``!=!P``7P<` M`&4'``!H!P``:0<``&L'``!M!P``=@<``'@'``!Y!P``>P<``'T'``"&!P`` MB <``(D'``"*!P``BP<``+$'``"^!P``S <``-D'``#@!P``X0<``.4'``#H M!P``ZP<``.X'``#O!P``]P<``/H'``#]!P````@```$(```"" ``^P`!S@<@ M`>X``<X'( '[``'.!R !^P`!S@<@`?L``<X'( '[``'.!R ![@`!S@<@`?L` M`<X'( '[``'.!R !^P`!S@<@`?L``<X'( 'N``'.!R !^P`!S@<@`?L``<X' M( '[``'.!R !^P`!S@<@`>X``<X'( '[``'.!R !^P`!S@<@`?L``<X'( '[ M``'.!R ![@`!S@<@`>D``< A( 'I``' (2 !Z0`!P"$@`?L``<X'( '[``'. M!R !^P`!S@<@`?L``<X'( 'N``'.!R !^P`!S@<@`?L``<X'( '[``'.!R ! M^P`!S@<@`>X``<X'( '[``'.!R !^P`!S@<@`?L``<X'( '[``'.!R ![@`! MS@<@`>D``< A( $```````````````0/`!$``!,!```,```8`1D!N&P`O@P` M!)3_.@C@$(89+"(```0/`!$``!@!`"D"" ```P@``!\\(```@" ``_@`!P"'P M`/X``< A6R'^``' (? ````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````````````````````0```PX`$ `( M``$`2P`/```````:``! \\?\\"`!H`!DYO<FUA; `"`````P!A"00````````` M````````````````(@!!0/+_H0`B`!9$969A=6QT(%!A<F%G<F%P:"!&;VYT M```````````````D`/Y/`0#R`"0`#$YO;B!);F1E;G0@-0`%``\\`$=@-``,` M8Q@````````@!0``" `@" ``!0#_____`@`$(?__`0``(/__`@``````/P0` M`" %``````(````!`````````P``.0@```4```,``+(&``!)!P```@@``" ( M```&``<`" `)``,%```;!0``'04``" %```3.I3_E8 `````(@4```<`,P`/ M07-H97(@4VAI<F%T>FMY($,Z7$UY($1O8W5M96YT<UQ344P@<75E<W1I;VXN M9&]C_T!(4"!,87-E<DIE=" T30!<7$YT87,R7&AP;&%S97(R`$A04$-,-4U3 M`$A0($QA<V5R2F5T(#1-`$A0($QA<V5R2F5T(#1-```````````````````` M``````0!!)0`0 `#9P`$`0`!``````````$`"0%8`@$``0!8`@0````````` M```````````````````````````````````````````````````````````` M```````````````````````"```````````````!`$ `35-51$X#2% @3&%S M97)*970@-$T```````````````````````#D`0```````#L!``````0`9 `* M````2% @3&%S97)*970@-$T`````````````````````````! $$E ! ``-G M``0!``$``````````0`)`5@"`0`!`%@"! `````````````````````````` M```````````````````````````````````````````````````````````` M``````(```````````````$`0 !-4U5$3@-(4"!,87-E<DIE=" T30`````` M`````````````````.0!````````.P$`````! !D``H````#@ $`W ```-P` M```'``$```#<`````````-P````Q`!46D $``%1I;65S($YE=R!2;VUA;@`, M%I !`@!3>6UB;VP`"R:0`0``07)I86P`(@`$`/$(B!@``- "``!H`0`````# M@Q(&TX02!@`````&``X```"]````.00```(``@````0`@Q )```````````` M```"``$````!`````````"0#`````#X````,4U%,('%U97-T:6]N````#T%S M:&5R(%-H:7)A='IK>0]!<VAE<B!3:&ER871Z:WD````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`-RE: !7X D$`````&4````````````````#```@" ``"A@````````````` M```````````@!0`````````````````````````````````````````````` M% ``D `````4``"0````D!0```````"0% ```````) 4````````D!0````` M``"0% ``% ```,H4````````RA0```````#*% ```````,H4````````RA0` M``````#*% ``"@```-04```<````RA0```````!#%P``,0```/ 4```6```` M!A4````````&%0````````85````````!A4````````&%0````````85```` M````!A4```````!#%0```@```$45````````114```````!%%0``. ```'T5 M``#4````418``-0````E%P``'@```'07``!8````S!<``#X```!#%P`````` M``````````````````````"0% ````````85```````````%``8``0`$``85 M````````!A4`````````````````````````````!A4````````&%0`````` M`$,7````````$!4```````"0% ```````) 4````````!A4````````````` M````````````````\\!0````````0%0```````! 5````````$!4````````& M%0``"@```) 4````````!A4```````"0% ````````85````````0Q4````` M`````````````*!)[)\\M'+P!I!0```X```"R% ``& ```) 4````````D!0` M``````"0% ```````) 4````````!A4```````!#%0```````! 5```S```` M$!4````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````%-13"!Q=65S=&EO;@T-26X@=&AE(&YE>'0@5&%B;&5S('1H97)E(&ES M(&%N()-!<W-E='.4('1A8FQE("P@DT%T=')I8G5T990@=&%B;&4@86YD(&$@ M8V]N;F5C=&EO;B!T86)L92!T:&%T('-P96-I9FEE<R!T:&4@5F%L=65S(&]F M("!A;B!A='1R:6)U=&4@9F]R