How to find a date from the previous record of a user in the same table

I have two tables, Coach (parent) and Meetings (child). The goal is to figure out if the next meeting is scheduled within 7 days of the last meeting the coach scheduled. So I need to somehow find the...