CREATE TABLE protein (common_name CLOB, protein_name CLOB, divergence_from_human_lineage FLOAT, accession_number CLOB, sequence_length FLOAT, sequence_identity_to_human_protein CLOB, Institution_id CLOB)
CREATE TABLE building (building_id CLOB, Name CLOB, Street_address CLOB, Years_as_tallest CLOB, Height_feet NUMBER, Floors NUMBER)
CREATE TABLE Institution (Institution_id CLOB, Institution CLOB, Location CLOB, Founded FLOAT, Type CLOB, Enrollment NUMBER, Team CLOB, Primary_Conference CLOB, building_id CLOB)

Bar chart x axis type y axis total number of enrollment, and rank by the Y from high to low.
SELECT Type, SUM(Enrollment) FROM Institution GROUP BY Type ORDER BY SUM(Enrollment) DESC
SELECT "Type", SUM("Enrollment") FROM "Institution" GROUP BY "Type" ORDER BY SUM("Enrollment") DESC