Get the details of latest transaction details of all employees based on selected transaction type

everyone. Some one who can help me to get the latest transaction details of employees based on selected transaction type. Below is the sample tables.

employees Table:

transactions Table:

Then now, I want to get list of employees and their latest transaction details where transaction_type is either [Add, Update, Read]

Below is my desired output:

As you can see, Jane Doe is not in the list, because her last transaction type is Delete which is not in the selected transaction type [Add, Update, Read]

Below is my Code:

<?php

$transaction_types = ['Add', 'Update', 'Read'];

$output = '';

$query = "SELECT * FROM transactions 
          INNER JOIN employees ON employees.employee_id = transactions.employee_id 
          WHERE transactions.transaction_type IN ('".implode("', '", $transaction_types)."') 
          GROUP BY transactions.employee_id 
          ORDER BY DATE(transactions.transaction_date) DESC
          ";
$stmt = $connect->prepare($query);
if ($stmt->execute()) {
   if ($stmt->rowCount() > 0) {
      $output .= '<table>
                    <thead>
                       <tr>
                          <th>Transaction ID</th>
                          <th>Employee Name</th>
                          <th>Transaction Date</th>
                          <th>Transaction Type</th>
                          <th>Remarks</th>
                       </tr>
                    </thead>
                    <tbody>';
      $result = $stmt->fetchAll();
      foreach ($result as $row) {
         $output .= '<tr>
                        <td>'.$row->transaction_id.'</td>
                        <td>'.$row->employee_name.'</td>
                        <td>'.$row->transaction_date.'</td>
                        <td>'.$row->transaction_type.'</td>
                        <td>'.$row->remarks.'</td>
                     </tr>';
      }
      $output .= '</tbody></table>';
   }
}

echo $output;

?>

you first have to remove the users with Delete from your results set and then use the row_number() window function with CTE to select the max dates

WITH cte
AS (
    SELECT t.transaction_id AS transaction_id
        ,t.transaction_date AS transaction_date
        ,row_number() OVER (
            PARTITION BY e.employee_name ORDER BY t.transaction_date DESC
            ) AS rn
        ,e.employee_name AS employee_name
        ,t.transaction_type AS transaction_type
        ,t.remarks AS remarks
    FROM employees e
    JOIN transactions t ON t.employee_id = e.employee_id
    WHERE e.employee_name NOT IN (
            SELECT e.employee_name
            FROM employees e
            JOIN transactions t ON t.employee_id = e.employee_id
            WHERE transaction_type = 'Delete'
            )
    )
SELECT cte.transaction_id
    ,cte.transaction_date
    ,cte.employee_name
    ,cte.transaction_type
    ,cte.remarks
FROM cte
WHERE rn = 1;

demo here