A business analyst needs to create a persistent data object named sales_by_employee that automatically updates when new data is inserted into the sales table. The object must contain two columns: sales_person (the employee's name from the employees table) and sales (the aggregated sales for that employee). The sales and employees tables can be joined using their common employee_id column.

Which of the following code blocks will achieve this?