Innovative Solutions interview question

Execution plan of java, join related queries