CREATE TABLE market (Market_ID NUMBER, Country CLOB, Number_cities NUMBER)
CREATE TABLE film (Film_ID NUMBER, Title CLOB, Studio CLOB, Director CLOB, Gross_in_dollar NUMBER)
CREATE TABLE film_market_estimation (Estimation_ID NUMBER, Low_Estimate FLOAT, High_Estimate FLOAT, Film_ID NUMBER, Type CLOB, Market_ID NUMBER, Year NUMBER)

How many films in each type? Show me a pie chart.
SELECT Type, COUNT(Type) FROM film AS T1 JOIN film_market_estimation AS T2 ON T1.Film_ID = T2.Film_ID GROUP BY Type
SELECT "Type", COUNT("Type") FROM "film" "T1" JOIN "film_market_estimation" "T2" ON "T1"."Film_ID" = "T2"."Film_ID" GROUP BY "Type"