I want an sql query for the below logic

, ,
1

How get the result of the below scenario:- suppose a participant is getting terminated in oct. So i want to get this into report on the base of the logic" end day of the month plus 30 days" measn any particpant who is getting termed on 8 or 9 oct then it should come on the report after end day of the oct + 30 days i.e. 30Nov

2

I think I get it, but to be clear, can you provide:

  1. CREATE TABLE statements for the tables involved
  2. INSERT INTO statements to populate the tables from step 1 with test data
  3. Your query so far
  4. Expected results using the test data from step 2.