Excellent. So that you're not drip-feeding information to us, please follow Phil's advice and post full table DDL and sample data.
Thanks
John
Edit - although I still don't think you've got enough information, because that last table you mentioned doesn't specify when the student started and finished in the class.