hi

just what is the last date of 30 day if not

take max(date of the month) let it be LastDateOfTrunt

select *

from stud a inner join stud b

on...