Fix Product Name Format
[]
['Create table If Not Exists Sales (sale_id int, product_name varchar(30), sale_date date)\n', 'Truncate table Sales', "insert into Sales (sale_id, product_name, sale_date) values ('1', 'LCPHONE', '2000-01-16')", "insert into Sales (sale_id, product_name, sale_date) values ('2', 'LCPhone', '2000-01-17')", "insert into Sales (sale_id, product_name, sale_date) values ('3', 'LcPhOnE', '2000-02-18')", "insert into Sales (sale_id, product_name, sale_date) values ('4', 'LCKeyCHAiN', '2000-02-19')", "insert into Sales (sale_id, product_name, sale_date) values ('5', 'LCKeyChain', '2000-02-28')", "insert into Sales (sale_id, product_name, sale_date) values ('6', 'Matryoshka', '2000-03-31')"]
{"mysql": ["Create table If Not Exists Sales (sale_id int, product_name varchar(30), sale_date date)\n"], "mssql": ["Create table Sales (sale_id int, product_name varchar(30), sale_date date)\n"], "oraclesql": ["Create table Sales (sale_id int, product_name varchar(30), sale_date date)\n", "ALTER SESSION SET nls_date_format='YYYY-MM-DD'\n"], "database": true, "name": "fix_name_format", "pythondata": ["Sales = pd.DataFrame([], columns=['sale_id', 'product_name', 'sale_date']).astype({'sale_id':'Int64', 'product_name':'object', 'sale_date':'datetime64[ns]'})"], "database_schema": {"Sales": {"sale_id": "INT", "product_name": "VARCHAR(30)", "sale_date": "DATE"}}}
{"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>"]}
['Database']