Question d’entretien chez Rakuten

1. Explain the SQL code (including WITH clause, left join...)