What is Lowest Rank, when Location is Rio De Janeiro, Brazil, and when Current Seating Capacity is less than 78,838?
CREATE TABLE table_name_42 (rank INTEGER, location VARCHAR, current_seating_capacity VARCHAR)
SELECT MIN(rank) FROM table_name_42 WHERE location = "rio de janeiro, brazil" AND current_seating_capacity < 78 OFFSET 838 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (rank INTEGER, location VARCHAR, current_seating_capacity VARCHAR) Question: What is Lowest Rank, when Location is Rio De Janeiro, Brazil, and when Current Seating Capacity is less than 78,838? [/INST] SELECT MIN(rank) FROM table_name_42 WHERE location = "rio de janeiro, brazil" AND current_seating_capacity < 78 OFFSET 838 ROWS </s>