select fname||' '||lname
from actormovie
where title = 'Titanic'
and year = '1997'
order by lname
/