What is the highest Rank, when Location is Kinshasa, DR Congo, and when Current Seating Capacity is less than 80,000?
CREATE TABLE table_name_90 (rank INTEGER, location VARCHAR, current_seating_capacity VARCHAR)
SELECT MAX(rank) FROM table_name_90 WHERE location = "kinshasa, dr congo" AND current_seating_capacity < 80 OFFSET 000 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_90 (rank INTEGER, location VARCHAR, current_seating_capacity VARCHAR) Question: What is the highest Rank, when Location is Kinshasa, DR Congo, and when Current Seating Capacity is less than 80,000? [/INST] SELECT MAX(rank) FROM table_name_90 WHERE location = "kinshasa, dr congo" AND current_seating_capacity < 80 OFFSET 000 ROWS </s>