Question d’entretien chez Rakuten

Write an SQL query to get information from these two tables.