Given a table of prescription transactions and a table of members, write a query to find the total prescriptions per member for the last 30 days.