Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_10528 ( "Rank" real, "Name" text, "Height ft (m)" text, "Floors" real, "Year" real )

### Question ###
What is the average amount of floors of the building that is ranked larger than 30, a year prior to 1977 and an address of 100 Van Ness Avenue?

### Accurate SQL ###

SELECT AVG("Floors") FROM table_10528 WHERE "Rank" > '30' AND "Year" < '1977' AND "Name" = '100 van ness avenue'