human
Schema:
building (building_id, Name, Street_address, Years_as_tallest, Height_feet, Floors)
Institution (Institution_id, Institution, Location, Founded, Type, Enrollment, Team, Primary_Conference, building_id)
protein (common_name, protein_name, divergence_from_human_lineage, accession_number, sequence_length, sequence_identity_to_human_protein, Institution_id)
Please answer with SQL.
assistant
Sure, I understand.
human
show the maximum number of floors for all buildings?
assistant
SELECT MAX( floors ) FROM building;
human
Show me the name of the building with building id 1?
assistant
SELECT name FROM building WHERE building_id = '1';
human
Show me the name of the building with 12 floors?
assistant
SELECT name FROM building WHERE floors = 12 ;