Journal Technologies Interview Question

Write a SQL query for us.