Re: Please help

use a decode (?) for the first question....

gordan ivetic wrote in message <379D15D0.8745C3B4_at_sympatico.ca>...
>I am having problem with those two question.
>Example1:
>The President wishes to present watches to those employees with over 10
>years experience.Print a list of these employees ranked by length of
>employment showing date hired, how long they have served and how many
>years it will take for them to reach 20 years.Show what date they will
>have achieved 20 years of service.This will be done with one select
>statement.
>
>Example2:
>The President wishes to give a rise to all employees.She has $10000 to
>divvy up amongst the employees in a fair and propotional way but needs
>some advice on how to do this.Print two charts(SELECTs )showing two
>options: the old and new salary should be listed and show how the $10000
>
>was used.You decide the two methods (eg.Based on present salary or on
>years of service ,etc).You may use the values obtained from getting the
>average, sum and count as literals in your select statements.
>
>Thank You.
>Tanja
>
>
>
>
Received on Tue Jul 27 1999 - 05:07:22 CEST