Ultimate access to all questions.
You have a view named employees_updates
that displays data of employees who have either joined or resigned from your organization in the last month. The view includes a column type
indicating the employee's status. There's also a Delta table employees
containing data for all current employees. Your goal is to integrate this Change Data Capture (CDC) feed by adding new employees and removing former employees from the employees
Delta table. Which query achieves this?