CREATE TABLE school (School_ID NUMBER, Grade CLOB, School CLOB, Location CLOB, Type CLOB)
CREATE TABLE school_bus (School_ID NUMBER, Driver_ID NUMBER, Years_Working NUMBER, If_full_time BOOLEAN)
CREATE TABLE driver (Driver_ID NUMBER, Name CLOB, Party CLOB, Home_city CLOB, Age NUMBER)

Show the type of school and the number of buses for each type in a bar chart, display y axis in descending order.
SELECT Type, COUNT(*) FROM school_bus AS T1 JOIN school AS T2 ON T1.School_ID = T2.School_ID GROUP BY T2.Type ORDER BY COUNT(*) DESC
SELECT "Type", COUNT(*) FROM "school_bus" "T1" JOIN "school" "T2" ON "T1"."School_ID" = "T2"."School_ID" GROUP BY "T2"."Type" ORDER BY COUNT(*) DESC