Which engineer has visited the most times? Show the engineer id, first name and last name.
create table maintenance_engineers (engineer_id varchar, first_name varchar, last_name varchar, PRIMARY KEY (engineer_id)); create table engineer_visits (id varchar, PRIMARY KEY (id))
select t1.engineer_id, t1.first_name, t1.last_name from maintenance_engineers as t1 join engineer_visits as t2 group by t1.engineer_id order by count(*) desc limit 1