Server Utilization Time
[]
["Create table if not exists Servers ( server_id int, status_time timestamp, session_status ENUM ('start','stop'))", 'Truncate table Servers', "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-29 20:22:50', 'start')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-30 04:19:50', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-18 21:23:09', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-19 00:38:09', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-27 18:38:16', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-28 02:46:16', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-27 06:46:42', 'start')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-27 08:23:42', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-11 05:09:45', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-11 06:42:45', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-27 23:05:58', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-27 23:48:58', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-14 16:29:34', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-14 19:11:34', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-02 19:14:15', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-02 20:19:15', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-03 06:55:30', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-03 11:03:30', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-02 16:53:28', 'start')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-02 22:28:28', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-20 07:06:41', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-20 15:58:41', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-22 10:42:35', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-22 19:14:35', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-23 03:05:39', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-23 10:54:39', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-15 20:04:15', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-15 21:30:15', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-12 08:21:42', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-12 17:07:42', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-02 02:33:24', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-02 12:10:24', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-14 03:55:29', 'start')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-14 08:53:29', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-04 00:36:53', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-04 00:37:53', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-08 01:54:18', 'start')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-08 09:56:18', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-24 14:28:11', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-24 21:38:11', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-20 22:55:03', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-21 02:19:03', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-12 03:10:22', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-12 08:29:22', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-02 14:55:46', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-02 16:56:46', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-09 03:40:44', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-09 03:52:44', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-16 17:43:28', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-16 20:45:28', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-08 16:17:24', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-09 00:59:24', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-25 04:46:06', 'start')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-25 11:56:06', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-05 14:22:34', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-05 21:33:34', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-02 09:49:22', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-02 15:01:22', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-08 06:49:10', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-08 13:33:10', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-22 21:00:23', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-22 22:43:23', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-06 07:45:50', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-06 15:18:50', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-02 22:13:17', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-03 03:50:17', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-14 02:40:20', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-14 03:57:20', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-08 21:13:00', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-09 01:22:00', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-21 13:25:22', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-21 19:46:22', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-16 04:37:55', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-16 12:53:55', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-06 14:03:26', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-06 17:11:26', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-11 08:18:54', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-11 12:34:54', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-07 22:54:01', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-08 08:22:01', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-23 14:08:03', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-23 22:23:03', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-04 15:20:41', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-04 16:09:41', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-05 01:24:32', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-05 10:09:32', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-09 14:15:29', 'start')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-09 18:39:29', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-28 21:43:00', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-29 06:06:00', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-18 06:23:14', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-18 07:34:14', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-09 17:27:02', 'start')", "insert into Servers (server_id, status_time, session_status) values ('5', '2023-11-10 03:00:02', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-21 02:41:57', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-21 07:28:57', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-08 00:36:12', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-08 01:47:12', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-15 16:13:39', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-15 20:29:39', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-03 06:25:01', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-03 11:14:01', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-18 20:49:55', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-18 23:04:55', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-13 05:02:21', 'start')", "insert into Servers (server_id, status_time, session_status) values ('3', '2023-11-13 12:44:21', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-23 19:00:11', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-24 04:59:11', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-20 01:16:38', 'start')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-20 01:35:38', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-13 11:21:08', 'start')", "insert into Servers (server_id, status_time, session_status) values ('1', '2023-11-13 11:56:08', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-21 23:09:45', 'start')", "insert into Servers (server_id, status_time, session_status) values ('4', '2023-11-22 00:26:45', 'stop')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-04 11:19:31', 'start')", "insert into Servers (server_id, status_time, session_status) values ('2', '2023-11-04 16:46:31', 'stop')"]
{"mysql": ["Create table if not exists Servers ( server_id int, status_time timestamp, session_status ENUM ('start','stop'))"], "mssql": ["Create table Servers (server_id int, status_time datetime,  session_status varchar(20) NOT NULL CHECK (session_status in ('start','stop')))"], "oraclesql": ["Create table  Servers (server_id int, status_time date,  session_status varchar(20) NOT NULL CHECK (session_status in ('start','stop')))", "ALTER SESSION SET nls_date_format='YYYY-MM-DD HH24:MI:SS'"], "database": true, "name": "server_utilization_time", "postgresql": ["Create table  Servers (server_id int, status_time timestamp,  session_status varchar(20) NOT NULL CHECK (session_status in ('start','stop')))"], "pythondata": ["Servers = pd.DataFrame([], columns=['server_id', 'status_time', 'session_status']).astype({'server_id': 'Int64', 'status_time': 'datetime64[ns]', 'session_status': pd.CategoricalDtype(categories=['start', 'stop'])})"], "database_schema": {"Servers": {"server_id": "INT", "status_time": "TIMESTAMP", "session_status": "ENUM('start', 'stop')"}}}
{"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']