select distinct title,ename,city,appdate from position natural join employer natural join applies natural where ((extract(year from appdate)='1999' and city='Sydney'));

TITLE                ENAME                            CITY                 APPDATE
-------------------- -------------------------------- -------------------- ---------
Professor            University of New South Wales    Sydney               27-OCT-99
Professor            University of New South Wales    Sydney               26-OCT-99
Lecturer             University of New South Wales    Sydney               13-DEC-99
Professor            University of New South Wales    Sydney               28-OCT-99
Senior Lecturer      University of Technology, Sydney Sydney               17-JUN-99
Senior Lecturer      University of Technology, Sydney Sydney               18-JUN-99
Senior Lecturer      University of Technology, Sydney Sydney               09-MAY-99

7 rows selected.

select fname,lname,title,ename from (select title,city,ename from position natural join employer) natural join applicant natural join applies where (extract(year from appdate)='1999' and city='Sydney');

FNAME           LNAME           TITLE                ENAME
--------------- --------------- -------------------- --------------------------------
John            Spiderman       Professor            University of New South Wales
John            Spiderman       Lecturer             University of New South Wales
Margaret        Finch           Professor            University of New South Wales
Margaret        Finch           Lecturer             University of New South Wales
John            Spiderman       Associate Professor  University of Technology, Sydney
John            Spiderman       Senior Lecturer      University of Technology, Sydney
Margaret        Finch           Associate Professor  University of Technology, Sydney
Margaret        Finch           Senior Lecturer      University of Technology, Sydney

8 rows selected.