What is the lowest number of engineer visits for a single fault log? List the number and log entry id.
select count(*), t1.fault_log_entry_id from fault_log as t1 join engineer_visits 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
Do the same for the highest number of engineer visits for a single fault log?
select count(*), t1.fault_log_entry_id from fault_log as t1 join engineer_visits 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