Need query to get who submitted resignation in last 24hours

we have a requirement to get the report of employees who submitted resignation.

Can anyone share me the query to get employees data or atleast how can we get data of employees before all the approvals completed.

Thanks,

Dara Nagasai