Rakuten interview question

SQL optimisation, project you have done