Westwing Group SE interview question

Questions about optimizing a slow MySQL query