Re: Please help

gordan ivetic 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.

Is this homework? Received on Tue Jul 27 1999 - 14:34:36 CEST