CREATE TABLE school_details (School_ID NUMBER, Nickname CLOB, Colors CLOB, League CLOB, Class CLOB, Division CLOB)
CREATE TABLE school (School_ID NUMBER, School CLOB, Location CLOB, Enrollment FLOAT, Founded FLOAT, Denomination CLOB, Boys_or_Girls CLOB, Day_or_Boarding CLOB, Year_Entered_Competition FLOAT, School_Colors CLOB)
CREATE TABLE school_performance (School_Id NUMBER, School_Year CLOB, Class_A CLOB, Class_AA CLOB)
CREATE TABLE player (Player_ID NUMBER, Player CLOB, Team CLOB, Age NUMBER, Position CLOB, School_ID NUMBER)

Create a bar chart showing the total number across denomination, rank in desc by the Y-axis.
SELECT Denomination, COUNT(*) FROM school GROUP BY Denomination ORDER BY COUNT(*) DESC
SELECT "Denomination", COUNT(*) FROM "school" GROUP BY "Denomination" ORDER BY COUNT(*) DESC