solution5.sql

SELECT c.name AS "Company Name", COUNT(cars.id) AS "Cars Not Displayed" FROM companies c LEFT JOIN cars ON c.id = cars.companyId LEFT JOIN eventParticipants ep ON cars.id = ep.carId WHERE ep.eventId IS NULL
GROUP BY c.name;