PocketPills interview question

Write a query in SQL using join.