Write a SQL query to join patient demographic tables with pharmacy transaction logs to find the most frequently filled prescriptions.
