SELECT T1.company_id ,  T1.company_name FROM Third_Party_Companies AS T1 JOIN Maintenance_Engineers AS T2 ON T1.company_id  =  T2.company_id GROUP BY T1.company_id HAVING count(*)  >=  2 UNION SELECT T3.company_id ,  T3.company_name FROM Third_Party_Companies AS T3 JOIN Maintenance_Contracts AS T4 ON T3.company_id  =  T4.maintenance_contract_company_id GROUP BY T3.company_id HAVING count(*)  >=  2
Which third party companies have at least 2 maintenance engineers or have at least 2 maintenance contracts? List the company id and name.
SELECT T1.company_id , T1.company_name FROM Third_Party_Companies AS T1 JOIN Maintenance_Engineers AS T2 ON T1.company_id = T2.company_id GROUP BY T1.company_id HAVING count ( * ) > = 2 UNION SELECT T3.company_id , T3.company_name FROM Third_Party_Companies AS T3 JOIN Maintenance_Contracts AS T4 ON T3.company_id = T4.maintenance_contract_company_id GROUP BY T3.company_id HAVING count ( * ) > = 2
select t1 . company_id , t1 . company_name from third_party_companies as t1 join maintenance_engineers as t2 on t1 . company_id = t2 . company_id group by t1 . company_id having count ( * ) > = value union select t3 . company_id , t3 . company_name from third_party_companies as t3 join maintenance_contracts as t4 on t3 . company_id = t4 . maintenance_contract_company_id group by t3 . company_id having count ( * ) > = value
Which third party companies have at least 2 maintenance engineers or have at least 2 maintenance contracts ? List the company id and name .