What would you expect for the following data?

INSERT INTO PRE_LOAD

(KitID, BatteryID, TestID, LBSTAT)

SELECT 'C1473045850','T1878','3730','NOT DONE' UNION ALL

SELECT 'C1473045850','T1878','3731','NOT DONE' UNION ALL

SELECT 'C1473045850','T1878','3732','NOT DONE' UNION ALL

SELECT 'C1473045850','T1878','3733','NOT DONE' UNION ALL

SELECT 'C1473045850','T1954','3730','' UNION ALL

SELECT 'C1473045850','T1954','3731',''