This query will show changes made to a vehicle Recall. The returned values of 0, 1, 2 are converted into words None, Open, Closed.

Tools: Oracle SQL.