Exercise 1
Write a PL/SQL program that calculates a "seniority ranking" based
for each sailor based on their age and rating. The formula is:
seniority = (rating * 2) + age
Sailors over the age of 40 get a 10 bonus seniority points.
Your program should print a list of all the sailors and their
seniority scores.
(Solution to Exercise 1)
Exercise 2
Write a PL/SQL program that prints a list of all the sailors
in order of sid. For sailors that reserved a red boat, print
an asterisk to the right of their name in the list.
(Solution to Exercise 2)
|