Employees With Deductions
[]
['Create table If Not Exists Employees (employee_id int, needed_hours int)', 'Create table If Not Exists Logs (employee_id int, in_time datetime, out_time datetime)', 'Truncate table Employees', "insert into Employees (employee_id, needed_hours) values ('1', '20')", "insert into Employees (employee_id, needed_hours) values ('2', '12')", "insert into Employees (employee_id, needed_hours) values ('3', '2')", 'Truncate table Logs', "insert into Logs (employee_id, in_time, out_time) values ('1', '2022-10-01 09:00:00', '2022-10-01 17:00:00')", "insert into Logs (employee_id, in_time, out_time) values ('1', '2022-10-06 09:05:04', '2022-10-06 17:09:03')", "insert into Logs (employee_id, in_time, out_time) values ('1', '2022-10-12 23:00:00', '2022-10-13 03:00:01')", "insert into Logs (employee_id, in_time, out_time) values ('2', '2022-10-29 12:00:00', '2022-10-29 23:58:58')"]
{"mysql": ["Create table If Not Exists Employees (employee_id int, needed_hours int)", "Create table If Not Exists Logs (employee_id int, in_time datetime, out_time datetime)"], "mssql": ["Create table Employees (employee_id int, needed_hours int)", "Create table Logs (employee_id int, in_time datetime, out_time datetime)"], "oraclesql": ["Create table Employees (employee_id int, needed_hours int)", "Create table Logs (employee_id int, in_time date, out_time date)", "ALTER SESSION SET nls_date_format='YYYY-MM-DD HH24:MI:SS'"], "database": true, "name": "employees_with_deductions", "pythondata": ["Employees = pd.DataFrame([], columns=['employee_id', 'needed_hours']).astype({'employee_id':'Int64', 'needed_hours':'Int64'})", "Logs = pd.DataFrame([], columns=['employee_id', 'in_time', 'out_time']).astype({'employee_id':'Int64', 'in_time':'datetime64[ns]', 'out_time':'datetime64[ns]'})"], "postgresql": ["Create table If Not Exists Employees (employee_id int, needed_hours int)\n", "Create table If Not Exists Logs (employee_id int, in_time timestamp, out_time timestamp)\n"], "database_schema": {"Employees": {"employee_id": "INT", "needed_hours": "INT"}, "Logs": {"employee_id": "INT", "in_time": "DATETIME", "out_time": "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']