Find Expensive Cities
[]
['Create Table if Not Exists Listings (listing_id int, city varchar(50), price int)', 'Truncate table Listings', "insert into Listings (listing_id, city, price) values ('113', 'LosAngeles', '7560386')", "insert into Listings (listing_id, city, price) values ('136', 'SanFrancisco', '2380268')", "insert into Listings (listing_id, city, price) values ('92', 'Chicago', '9833209')", "insert into Listings (listing_id, city, price) values ('60', 'Chicago', '5147582')", "insert into Listings (listing_id, city, price) values ('8', 'Chicago', '5274441')", "insert into Listings (listing_id, city, price) values ('79', 'SanFrancisco', '8372065')", "insert into Listings (listing_id, city, price) values ('37', 'Chicago', '7939595')", "insert into Listings (listing_id, city, price) values ('53', 'LosAngeles', '4965123')", "insert into Listings (listing_id, city, price) values ('178', 'SanFrancisco', '999207')", "insert into Listings (listing_id, city, price) values ('51', 'NewYork', '5951718')", "insert into Listings (listing_id, city, price) values ('121', 'NewYork', '2893760')"]
{"mysql": ["Create Table if Not Exists Listings (listing_id int, city varchar(50), price int)"], "mssql": ["Create Table Listings (listing_id int, city varchar(50), price int)"], "oraclesql": ["Create Table  Listings (listing_id int, city varchar(50), price int)"], "database": true, "name": "find_expensive_cities", "postgresql": ["CREATE TABLE Listings (\n  listing_id SERIAL PRIMARY KEY,\n  city VARCHAR(50),\n  price INT\n);\n"], "pythondata": ["Listings = pd.DataFrame([], columns=['listing_id', 'city', 'price']).astype({'listing_id':'Int64', 'city':'object', 'price':'Int64'})\n"], "database_schema": {"Listings": {"listing_id": "INT", "city": "VARCHAR(50)", "price": "INT"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']