Sorry, you are wrong. The first is not correct as the condition is on the wrong column - dob rather than join_date. The second is correct as each month's full...