CREATE TABLE protein (common_name CLOB, protein_name CLOB, divergence_from_human_lineage NUMBER, accession_number CLOB, sequence_length NUMBER, sequence_identity_to_human_protein CLOB, institution_id CLOB)
CREATE TABLE institution (institution_id CLOB, institution CLOB, location CLOB, founded NUMBER, type CLOB, enrollment NUMBER, team CLOB, primary_conference CLOB, building_id CLOB)
CREATE TABLE building (building_id CLOB, name CLOB, street_address CLOB, years_as_tallest CLOB, height_feet NUMBER, floors NUMBER)

Show the number of buildings with a height above the average or a number of floors above the average.
SELECT COUNT(*) FROM building WHERE height_feet > (SELECT AVG(height_feet) FROM building) OR floors > (SELECT AVG(floors) FROM building)
SELECT COUNT(*) FROM "building" WHERE "floors" > (SELECT AVG("floors") FROM "building") OR "height_feet" > (SELECT AVG("height_feet") FROM "building")