Rakuten Interview Question

SQL optimisation, project you have done