PocketPills Interview Question

Write a query in SQL using join.