igeligel · June 17, 2019 10:34
diff --git a/group-by.sql b/group-by.sql
 SELECT SUM(price),
       CASE
           WHEN name = ANY (ARRAY ['Airbus A333-300', 'Airbus A380-800']) THEN 'airplane'
           WHEN name = ANY (ARRAY ['Volkswagen Golf', 'Porsche Cayenne']) THEN 'car'
           ELSE null
           END AS type
 FROM vehicles
 GROUP BY vehicle_type;
	SELECT SUM(price),
	CASE
	WHEN name = ANY (ARRAY ['Airbus A333-300', 'Airbus A380-800']) THEN 'airplane'
	WHEN name = ANY (ARRAY ['Volkswagen Golf', 'Porsche Cayenne']) THEN 'car'
	ELSE null
	END AS type
	FROM vehicles
	GROUP BY vehicle_type;