Nesting column functions within scalar functions

Suppose that you want to know the year in which the last project in department 20 will be initiated. If you run this query:

SELECT YEAR(MAX(STARTD))
  FROM Q.PROJECT
  WHERE DEPT = 20

QMF produces this report:

    LAST
   PROJECT
    START
----------
      1997
[ Previous Page | Next Page | Contents | Index ]