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)

Show me the total number by studio in a histogram, I want to rank by the bar in asc.
SELECT Studio, COUNT(*) FROM film GROUP BY Studio ORDER BY Studio
SELECT "Studio", COUNT(*) FROM "film" GROUP BY "Studio" ORDER BY "Studio"