Generate two tables with filter from another table

[TaufikMaggangka]

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

[lbendlin]

I don't understand what you are trying to measure. Attendance outside the academic calendar?

See attached for a proposed data model.  Can you indicate the expected outcome?