List the Products Ordered in a Period
<p>Table: <code>Products</code></p>

<pre>
+------------------+---------+
| Column Name      | Type    |
+------------------+---------+
| product_id       | int     |
| product_name     | varchar |
| product_category | varchar |
+------------------+---------+
product_id is the primary key (column with unique values) for this table.
This table contains data about the company&#39;s products.
</pre>

<p>&nbsp;</p>

<p>Table: <code>Orders</code></p>

<pre>
+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| product_id    | int     |
| order_date    | date    |
| unit          | int     |
+---------------+---------+
This table may have duplicate rows.
product_id is a foreign key (reference column) to the Products table.
unit is the number of products ordered in order_date.
</pre>

<p>&nbsp;</p>

<p>Write a solution to get the names of products that have at least <code>100</code> units ordered in <strong>February 2020</strong> and their amount.</p>

<p>Return the result table in <strong>any order</strong>.</p>

<p>The&nbsp;result format is in the following example.</p>

<p>&nbsp;</p>
<p><strong class="example">Example 1:</strong></p>

<pre>
<strong>Input:</strong> 
Products table:
+-------------+-----------------------+------------------+
| product_id  | product_name          | product_category |
+-------------+-----------------------+------------------+
| 1           | Leetcode Solutions    | Book             |
| 2           | Jewels of Stringology | Book             |
| 3           | HP                    | Laptop           |
| 4           | Lenovo                | Laptop           |
| 5           | Leetcode Kit          | T-shirt          |
+-------------+-----------------------+------------------+
Orders table:
+--------------+--------------+----------+
| product_id   | order_date   | unit     |
+--------------+--------------+----------+
| 1            | 2020-02-05   | 60       |
| 1            | 2020-02-10   | 70       |
| 2            | 2020-01-18   | 30       |
| 2            | 2020-02-11   | 80       |
| 3            | 2020-02-17   | 2        |
| 3            | 2020-02-24   | 3        |
| 4            | 2020-03-01   | 20       |
| 4            | 2020-03-04   | 30       |
| 4            | 2020-03-04   | 60       |
| 5            | 2020-02-25   | 50       |
| 5            | 2020-02-27   | 50       |
| 5            | 2020-03-01   | 50       |
+--------------+--------------+----------+
<strong>Output:</strong> 
+--------------------+---------+
| product_name       | unit    |
+--------------------+---------+
| Leetcode Solutions | 130     |
| Leetcode Kit       | 100     |
+--------------------+---------+
<strong>Explanation:</strong> 
Products with product_id = 1 is ordered in February a total of (60 + 70) = 130.
Products with product_id = 2 is ordered in February a total of 80.
Products with product_id = 3 is ordered in February a total of (2 + 3) = 5.
Products with product_id = 4 was not ordered in February 2020.
Products with product_id = 5 is ordered in February a total of (50 + 50) = 100.
</pre>

[]
['Create table If Not Exists Products (product_id int, product_name varchar(40), product_category varchar(40))', 'Create table If Not Exists Orders (product_id int, order_date date, unit int)', 'Truncate table Products', "insert into Products (product_id, product_name, product_category) values ('1', 'Leetcode Solutions', 'Book')", "insert into Products (product_id, product_name, product_category) values ('2', 'Jewels of Stringology', 'Book')", "insert into Products (product_id, product_name, product_category) values ('3', 'HP', 'Laptop')", "insert into Products (product_id, product_name, product_category) values ('4', 'Lenovo', 'Laptop')", "insert into Products (product_id, product_name, product_category) values ('5', 'Leetcode Kit', 'T-shirt')", 'Truncate table Orders', "insert into Orders (product_id, order_date, unit) values ('1', '2020-02-05', '60')", "insert into Orders (product_id, order_date, unit) values ('1', '2020-02-10', '70')", "insert into Orders (product_id, order_date, unit) values ('2', '2020-01-18', '30')", "insert into Orders (product_id, order_date, unit) values ('2', '2020-02-11', '80')", "insert into Orders (product_id, order_date, unit) values ('3', '2020-02-17', '2')", "insert into Orders (product_id, order_date, unit) values ('3', '2020-02-24', '3')", "insert into Orders (product_id, order_date, unit) values ('4', '2020-03-01', '20')", "insert into Orders (product_id, order_date, unit) values ('4', '2020-03-04', '30')", "insert into Orders (product_id, order_date, unit) values ('4', '2020-03-04', '60')", "insert into Orders (product_id, order_date, unit) values ('5', '2020-02-25', '50')", "insert into Orders (product_id, order_date, unit) values ('5', '2020-02-27', '50')", "insert into Orders (product_id, order_date, unit) values ('5', '2020-03-01', '50')"]
[{"value": "mysql", "text": "MySQL", "defaultCode": "# Write your MySQL query statement below\n"}, {"value": "mssql", "text": "MS SQL Server", "defaultCode": "/* Write your T-SQL query statement below */\n"}, {"value": "oraclesql", "text": "Oracle", "defaultCode": "/* Write your PL/SQL query statement below */\n"}, {"value": "pythondata", "text": "Pandas", "defaultCode": "import pandas as pd\n\ndef list_products(products: pd.DataFrame, orders: pd.DataFrame) -> pd.DataFrame:\n    "}, {"value": "postgresql", "text": "PostgreSQL", "defaultCode": "-- Write your PostgreSQL query statement below\n"}]
{"mysql": ["Create table If Not Exists Products (product_id int, product_name varchar(40), product_category varchar(40))", "Create table If Not Exists Orders (product_id int, order_date date, unit int)"], "mssql": ["Create table Products (product_id int, product_name varchar(40), product_category varchar(40))\n", "Create table Orders (product_id int, order_date date, unit int)"], "oraclesql": ["Create table Products (product_id int, product_name varchar(40), product_category varchar(40))", "Create table Orders (product_id int, order_date date, unit int)", "ALTER SESSION SET nls_date_format='YYYY-MM-DD'"], "database": true, "name": "list_products", "pythondata": ["Products = pd.DataFrame([], columns=['product_id', 'product_name', 'product_category']).astype({'product_id':'Int64', 'product_name':'object', 'product_category':'object'})", "Orders = pd.DataFrame([], columns=['product_id', 'order_date', 'unit']).astype({'product_id':'Int64', 'order_date':'datetime64[ns]', 'unit':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Products (product_id int, product_name varchar(40), product_category varchar(40))", "Create table If Not Exists Orders (product_id int, order_date date, unit int)"], "database_schema": {"Products": {"product_id": "INT", "product_name": "VARCHAR(40)", "product_category": "VARCHAR(40)"}, "Orders": {"product_id": "INT", "order_date": "DATE", "unit": "INT"}}}
{"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']