Journal Technologies interview question

Write a SQL query for us.