COOX interview question

Questions around backend and SQL joins