if you want all remaining model as it is then please try this query

SELECT

CASE

WHEN CARS.Model LIKE '%Ford%' THEN 'Ford'

WHEN CARS.Model LIKE '%Chev%' THEN 'Chev'

WHEN CARS.Model LIKE '%Buick%' THEN 'Buick'

ELSE CARS.Model

END AS 'Models'

FROM CARS