Show ID and first and last name of Engineer who has visited the most times.
select t1.engineer_id, t1.first_name, t1.last_name from maintenance_engineers as t1 join engineer_visits as t2 on t1.engineer_id = t2.engineer_id group by t1.engineer_id order by count ( * ) desc limit 1
what is the fault status of Engineer with the first name Etha?
select t2.fault_status from maintenance_engineers as t1 join engineer_visits as t2 on t1.engineer_id = t2.engineer_id where t1.first_name = "Etha"
What is the visit start DateTime of Engineer with the first name Etha?
select t2.visit_start_datetime from maintenance_engineers as t1 join engineer_visits as t2 on t1.engineer_id = t2.engineer_id where t1.first_name = "Etha"
What is the visit end datetime of Engineer with the first name Etha?
select t2.visit_end_datetime from maintenance_engineers as t1 join engineer_visits as t2 on t1.engineer_id = t2.engineer_id where t1.first_name = "Etha"