--3.1How many vehicles have more than one installation event?
SELECT COUNT(1) FROM
(SELECT COUNT(v.vehicle_id), v.vehicle_id
FROM generic_event ge, vehicle v
WHERE v.vehicle_id=ge.vehicle_id
AND ge.name LIKE 'Traxxeo install'
GROUP BY v.vehicle_id
HAVING COUNT(v.vehicle_id )>1);