Re: I need help...

Would this be your homework that you are asking us to do?

On Mon, 26 Jul 1999 22:36:54 GMT, gordan ivetic <gord001_at_sympatico.ca> wrote:

>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 Mon Jul 26 1999 - 23:46:50 CDT