Sellers With No Sales
['customer-who-visited-but-did-not-make-any-transactions']
['Create table If Not Exists Customer (customer_id int, customer_name varchar(20))', 'Create table If Not Exists Orders (order_id int, sale_date date, order_cost int, customer_id int, seller_id int)\n', 'Create table If Not Exists Seller (seller_id int, seller_name varchar(20))\n', 'Truncate table Customer', "insert into Customer (customer_id, customer_name) values ('101', 'Alice')", "insert into Customer (customer_id, customer_name) values ('102', 'Bob')", "insert into Customer (customer_id, customer_name) values ('103', 'Charlie')", 'Truncate table Orders', "insert into Orders (order_id, sale_date, order_cost, customer_id, seller_id) values ('1', '2020-03-01', '1500', '101', '1')", "insert into Orders (order_id, sale_date, order_cost, customer_id, seller_id) values ('2', '2020-05-25', '2400', '102', '2')", "insert into Orders (order_id, sale_date, order_cost, customer_id, seller_id) values ('3', '2019-05-25', '800', '101', '3')", "insert into Orders (order_id, sale_date, order_cost, customer_id, seller_id) values ('4', '2020-09-13', '1000', '103', '2')", "insert into Orders (order_id, sale_date, order_cost, customer_id, seller_id) values ('5', '2019-02-11', '700', '101', '2')", 'Truncate table Seller', "insert into Seller (seller_id, seller_name) values ('1', 'Daniel')", "insert into Seller (seller_id, seller_name) values ('2', 'Elizabeth')", "insert into Seller (seller_id, seller_name) values ('3', 'Frank')"]
{"mysql": ["Create table If Not Exists Customer (customer_id int, customer_name varchar(20))", "Create table If Not Exists Orders (order_id int, sale_date date, order_cost int, customer_id int, seller_id int)\n", "Create table If Not Exists Seller (seller_id int, seller_name varchar(20))\n"], "mssql": ["Create table Customer (customer_id int, customer_name varchar(20))\n", "Create table Orders (order_id int, sale_date date, order_cost int, customer_id int, seller_id int)\n", "Create table Seller (seller_id int, seller_name varchar(20))\n"], "oraclesql": ["Create table Customer (customer_id int, customer_name varchar(20))\n", "Create table Orders (order_id int, sale_date date, order_cost int, customer_id int, seller_id int)\n", "Create table Seller (seller_id int, seller_name varchar(20))\n", "ALTER SESSION SET nls_date_format='YYYY-MM-DD'\n"], "database": true, "manual": false, "name": "sellers_with_no_sales", "pythondata": ["Customer = pd.DataFrame([], columns=['customer_id', 'customer_name']).astype({'customer_id':'Int64', 'customer_name':'object'})", "Orders = pd.DataFrame([], columns=['order_id', 'sale_date', 'order_cost', 'customer_id', 'seller_id']).astype({'order_id':'Int64', 'sale_date':'datetime64[ns]', 'order_cost':'Int64', 'customer_id':'Int64', 'seller_id':'Int64'})", "Seller = pd.DataFrame([], columns=['seller_id', 'seller_name']).astype({'seller_id':'Int64', 'seller_name':'object'})"], "postgresql": ["\nCreate table If Not Exists Customer (customer_id int, customer_name varchar(20))\n", "Create table If Not Exists Orders (order_id int, sale_date date, order_cost int, customer_id int, seller_id int)", "Create table If Not Exists Seller (seller_id int, seller_name varchar(20))\n"], "database_schema": {"Customer": {"customer_id": "INT", "customer_name": "VARCHAR(20)"}, "Orders": {"order_id": "INT", "sale_date": "DATE", "order_cost": "INT", "customer_id": "INT", "seller_id": "INT"}, "Seller": {"seller_id": "INT", "seller_name": "VARCHAR(20)"}}}
{"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']