Generate two tables with filter from another table

Hi Expert,

I have case where I need to generate new table from 2 tables which are Date table and also school table with condition that the result of date that generate only if existed on the start and end date of the academic year table and also student attendance date on the attendance table.

I already create sampel data set here based on my conditions above(Link)

Thank so much