In this scenario, we should use standard query or incremental query activity? Incremental Query
normal email delivery or recurring delivery? Neither, Go with Continous delivery
say for example there is a field called date join in the table. How to query people who have date join is last month?
With an Incremental Query, if you schedule it to run monthly with history saved permanently, you shouldn't need any query but it's not ideal, it may cause problems with migration and upgrade so use below query: