igeligel · June 17, 2019 10:34
diff --git a/base-case.sql b/base-case.sql
 SELECT *,
       CASE
           WHEN name = 'Airbus A333-300' THEN 'airplane'
           WHEN name = 'Airbus A380-800' THEN 'airplane'
           WHEN name = 'Volkswagen Golf' THEN 'car'
           WHEN name = 'Porsche Cayenne' THEN 'car'
           ELSE null
           END AS type
 FROM vehicles;
	SELECT *,
	CASE
	WHEN name = 'Airbus A333-300' THEN 'airplane'
	WHEN name = 'Airbus A380-800' THEN 'airplane'
	WHEN name = 'Volkswagen Golf' THEN 'car'
	WHEN name = 'Porsche Cayenne' THEN 'car'
	ELSE null
	END AS type
	FROM vehicles;