Pregunta de entrevista de Rakuten

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