Few queries in carfax report

I am planning to buy this nissan rogue 2015 SV AWD.
When i came across the car fax report.
The below entries puzzle me
- How the safety inspection failed and passed on the same day?
- What does this mean - "Computer reprogrammed
Transmission computer/module reprogrammed"?
- It seems they did something right before the auction. It seems fishy
- But, this thing is now a certified pre-owned vehicle. So, does this mean it is a safe car to buy?

Any help here would be greatly appreciated!! Thanks!

https://www.carfax.com/VehicleHistory/p/Report.cfx?partner=EBZ_0&vin=KNMAT2MV4FP529822&source=BUP




[TABLE="width: 100%"]
[TR="class: evenrow"]
[TD="bgcolor: #E6EDF5"]04/10/2017 [/TD]
[TD="class: mileage, bgcolor: #E6EDF5, align: right"]23,390 [/TD]
[TD="bgcolor: #E6EDF5"]New York
Inspection Station[/TD]
[TD="bgcolor: #E6EDF5"]Failed safety inspection
Passed emissions inspection

View what was inspected
[/TD]
[/TR]
[TR="class: oddrow"]
[TD]04/10/2017 [/TD]
[TD="class: mileage, align: right"]23,397 [/TD]
[TD]New York
Inspection Station[/TD]
[TD]Passed safety inspection
Passed emissions inspection

View what was inspected
[/TD]
[/TR]
[TR="class: evenrow"]
[TD="bgcolor: #E6EDF5"]12/30/2017 [/TD]
[TD="class: mileage, bgcolor: #E6EDF5, align: right"]31,507 [/TD]
[TD="bgcolor: #E6EDF5"]Route 33 Nissan
Trenton, NJ
609-586-1900
route33nissan.com[/TD]
[TD="bgcolor: #E6EDF5"]Computer reprogrammed
Transmission computer/module reprogrammed

[/TD]
[/TR]
[/TABLE]
[TABLE="width: 100%"]
[TR="class: oddrow"]
[TD]01/01/2018 [/TD]
[TD="class: mileage, align: right"] [/TD]
[TD]Auto Auction
Eastern Region[/TD]
[TD]Vehicle sold at auction[/TD]
[/TR]
[/TABLE]