我从用户那里得到了from date和to date。我想退回已售出产品的价格及其在每日售出订单的基础上的计数。怎么做？

SELECT 
    sale_date, 
    SUM(price * quantity) AS total_price, 
    SUM(quantity) AS total_quantity
FROM 
    sales
WHERE 
    sale_date BETWEEN 'from date' AND 'to date'
GROUP BY 
    sale_date;

import sqlite3
from datetime import datetime

# 连接到数据库
conn = sqlite3.connect('sales.db')
cursor = conn.cursor()

# 用户输入的日期范围
from_date = '2023-01-01'
to_date = '2023-01-31'

# 执行SQL查询
cursor.execute("""
SELECT 
    sale_date, 
    SUM(price * quantity) AS total_price, 
    SUM(quantity) AS total_quantity
FROM 
    sales
WHERE 
    sale_date BETWEEN ? AND ?
GROUP BY 
    sale_date;
""", (from_date, to_date))

# 获取查询结果
results = cursor.fetchall()

# 打印结果
for row in results:
    print(f"Date: {row[0]}, Total Price: {row[1]}, Total Quantity: {row[2]}")

# 关闭数据库连接
conn.close()