Second Day Verification
[]
['CREATE TABLE If not exists emails (\n    email_id INT,\n    user_id INT,\n    signup_date DATETIME\n);', "CREATE TABLE If not exists texts (\n    text_id INT,\n    email_id INT,\n    signup_action ENUM('Verified', 'Not Verified'),\n    action_date DATETIME\n);", 'Truncate table emails', "insert into emails (email_id, user_id, signup_date) values ('125', '7771', '2022-06-14 09:30:00')", "insert into emails (email_id, user_id, signup_date) values ('433', '1052', '2022-07-09 08:15:00')", "insert into emails (email_id, user_id, signup_date) values ('234', '7005', '2022-08-20 10:00:00')", 'Truncate table texts', "insert into texts (text_id, email_id, signup_action, action_date) values ('1', '125', 'Verified', '2022-06-15 08:30:00')", "insert into texts (text_id, email_id, signup_action, action_date) values ('2', '433', 'Not Verified', '2022-07-10 10:45:00')", "insert into texts (text_id, email_id, signup_action, action_date) values ('4', '234', 'Verified', '2022-08-21 09:30:00')"]
{"mysql": ["CREATE TABLE If not exists emails (\n    email_id INT,\n    user_id INT,\n    signup_date DATETIME\n);", "CREATE TABLE If not exists texts (\n    text_id INT,\n    email_id INT,\n    signup_action ENUM('Verified', 'Not Verified'),\n    action_date DATETIME\n);"], "mssql": ["CREATE TABLE emails (\n    email_id INT,\n    user_id INT,\n    signup_date DATETIME\n);", "CREATE TABLE texts (\n    text_id INT,\n    email_id INT,\n    signup_action VARCHAR(12),\n    action_date DATETIME\n);"], "oraclesql": ["CREATE TABLE emails (\n    email_id NUMBER,\n    user_id NUMBER,\n    signup_date DATE\n)\n", "CREATE TABLE texts (\n    text_id NUMBER,\n    email_id NUMBER,\n    signup_action VARCHAR(32),\n    action_date DATE\n)", "ALTER SESSION SET nls_date_format='YYYY-MM-DD HH24:MI:SS'"], "database": true, "name": "find_second_day_signups", "postgresql": ["CREATE TABLE emails (\n    email_id INTEGER,\n    user_id INTEGER,\n    signup_date DATE\n);\n", "CREATE TABLE texts (\n    text_id INTEGER,\n    email_id INTEGER,\n    signup_action VARCHAR(32),\n    action_date DATE\n);\n", "SELECT to_char(action_date, 'YYYY-MM-DD HH24:MI:SS') FROM texts;\n"], "pythondata": ["emails = pd.DataFrame([], columns=['email_id', 'user_id', 'signup_date']).astype({\n    'email_id': 'Int64',  # Nullable integer type\n    'user_id': 'Int64',   # Nullable integer type\n    'signup_date': 'datetime64[ns]'  # DateTime type for signup date\n})", "texts = pd.DataFrame([], columns=['text_id', 'email_id', 'signup_action', 'action_date']).astype({\n    'text_id': 'Int64',             # Nullable integer type for text_id\n    'email_id': 'Int64',            # Nullable integer type for email_id\n    'signup_action': 'object',      # Using 'object' to store string values for ENUM\n    'action_date': 'datetime64[ns]' # DateTime type for action_date\n})"], "database_schema": {"emails": {"email_id": "INT", "user_id": "INT", "signup_date": "DATETIME"}, "texts": {"text_id": "INT", "email_id": "INT", "signup_action": "ENUM('Verified', 'Not Verified')", "action_date": "DATETIME"}}}
{"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']