Which fault log included the least number of faulty parts? List the id, description, and record time of that fault log.
select t1.fault_log_entry_id, 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 group by t1.fault_log_entry_id order by count(*) asc limit 1
Show the same for the fault log with most number of faulty parts.
select t1.fault_log_entry_id, 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 group by t1.fault_log_entry_id order by count(*) desc limit 1