athenahealth interview question

They asked realtime mysql queries using joins