Macquarie Group Interview Question

Questions on Inner/Out Joins how to optimize Inner Join