Rakuten interview question

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