How many fault status codes are recorded in the fault log parts table?
SELECT DISTINCT fault_status FROM Fault_Log_Parts
count of fault status codes refers to COUNT(DISTINCT fault_status); recorded in the fault log parts table refers to FROM Fault_Log_Parts;