Google L5 level Interview: If You Join 10 Tables in an SQL Query, How Would You Optimize…

During a recent technical interview at Goofle, a candidate was asked a challenging question: