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

Use a stacked bar chart to show how many films for each title and each type The x-axis is title, display y axis in ascending order.
SELECT Title, COUNT(Title) FROM film AS T1 JOIN film_market_estimation AS T2 ON T1.Film_ID = T2.Film_ID GROUP BY Type, Title ORDER BY COUNT(Title)
SELECT "Title", COUNT("Title") FROM "film" AS "T1" JOIN "film_market_estimation" AS "T2" ON "T1"."Film_ID" = "T2"."Film_ID" GROUP BY "Type", "Title" ORDER BY COUNT("Title") NULLS FIRST