Cloudmark interview question

How would you optimize the following Oracle SQL query...

Interview Answer

Anonymous

5 May 2012

This query was in a version of SQL I had not used for about 8 years and I was not applying to be a database engineer, but a web developer. You will be tested at the edges of your expertise.