Can you list all the unique fault log entry ids?
select distinct fault_log_entry_id from fault_log
Can you count the number of unique part fault ids that belong to each unique fault log entry id, and then add those values to the table?
select fault_log_entry_id, count ( * ) from fault_log_parts group by fault_log_entry_id
Amazing, can you display only the entry with a fault log id of 1 as well as the description and record time for that entry with a fault log id of 1?
select count ( * ), *, t1.fault_description, t1.fault_log_entry_datetime from fault_log as t1 join fault_log_parts as t2 on t1.fault_log_entry_id = t2.fault_log_entry_id where t1.fault_log_entry_id = 1 group by t1.fault_log_entry_id order by count ( * ) desc limit 1