-- Step 6
create view category_aggregate (category, total_places, total_chairs) as
	select
		category,
		count(cafe),
		sum(number_of_chairs)
	from street_cafes group by category;