Friend Requests I: Overall Acceptance Rate
[]
['Create table If Not Exists FriendRequest (sender_id int, send_to_id int, request_date date)', 'Create table If Not Exists RequestAccepted (requester_id int, accepter_id int, accept_date date)', 'Truncate table FriendRequest', "insert into FriendRequest (sender_id, send_to_id, request_date) values ('1', '2', '2016/06/01')", "insert into FriendRequest (sender_id, send_to_id, request_date) values ('1', '3', '2016/06/01')", "insert into FriendRequest (sender_id, send_to_id, request_date) values ('1', '4', '2016/06/01')", "insert into FriendRequest (sender_id, send_to_id, request_date) values ('2', '3', '2016/06/02')", "insert into FriendRequest (sender_id, send_to_id, request_date) values ('3', '4', '2016/06/09')", 'Truncate table RequestAccepted', "insert into RequestAccepted (requester_id, accepter_id, accept_date) values ('1', '2', '2016/06/03')", "insert into RequestAccepted (requester_id, accepter_id, accept_date) values ('1', '3', '2016/06/08')", "insert into RequestAccepted (requester_id, accepter_id, accept_date) values ('2', '3', '2016/06/08')", "insert into RequestAccepted (requester_id, accepter_id, accept_date) values ('3', '4', '2016/06/09')", "insert into RequestAccepted (requester_id, accepter_id, accept_date) values ('3', '4', '2016/06/10')"]
{"mysql": ["Create table If Not Exists FriendRequest (sender_id int, send_to_id int, request_date date)", "Create table If Not Exists RequestAccepted (requester_id int, accepter_id int, accept_date date)"], "mssql": ["Create table FriendRequest (sender_id int, send_to_id int, request_date date)", "Create table RequestAccepted (requester_id int, accepter_id int, accept_date date)"], "oraclesql": ["Create table FriendRequest (sender_id int, send_to_id int, request_date date)", "Create table RequestAccepted (requester_id int, accepter_id int, accept_date date)", "Alter SESSION set NLS_DATE_FORMAT = 'YYYY/MM/DD'"], "database": true, "name": "acceptance_rate", "pythondata": ["FriendRequest = pd.DataFrame([], columns=['sender_id', 'send_to_id', 'request_date']).astype({'sender_id':'Int64', 'send_to_id':'Int64', 'request_date':'datetime64[ns]'})", "RequestAccepted = pd.DataFrame([], columns=['requester_id', 'accepter_id', 'accept_date']).astype({'requester_id':'Int64', 'accepter_id':'Int64', 'accept_date':'datetime64[ns]'})"], "postgresql": ["Create table If Not Exists FriendRequest (sender_id int, send_to_id int, request_date date)", "Create table If Not Exists RequestAccepted (requester_id int, accepter_id int, accept_date date)"], "database_schema": {"FriendRequest": {"sender_id": "INT", "send_to_id": "INT", "request_date": "DATE"}, "RequestAccepted": {"requester_id": "INT", "accepter_id": "INT", "accept_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>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']