查询既订购了“酷睿四核”商品，又订购了“华为手环”商品的客户编号、订单编号和订单金额。客户编号：customerNo，订单编号：orderNo，订单金额：ordersum，

在这种情况下，你需要构造一个包含多个条件的SQL查询，比如使用AND操作符将两个商品名称作为搜索条件。以下是使用Python和SQLite示例（其他数据库语法类似）：

import sqlite3

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

# 定义查询条件
core_quartet_item = '酷睿四核'
huawei_bracelet_item = '华为手环'

# 构造SQL查询
sql_query = f"""
SELECT customerNo, orderNo, SUM(ordersum) as total_amount
FROM (
    SELECT customerNo, orderNo, SUM(price * quantity) as ordersum
    FROM Orders
    JOIN OrderDetails ON Orders.orderId = OrderDetails.orderId
    WHERE product_name = '{core_quartet_item}' OR product_name = '{huawei_bracelet_item}'
    GROUP BY customerNo, orderNo
) AS subquery
GROUP BY customerNo, orderNo
HAVING COUNT(DISTINCT product_name) = 2;
"""

# 执行查询
cursor.execute(sql_query)

# 获取结果
results = cursor.fetchall()
for row in results:
    customer_no, order_no, total_amount = row
    print(f"客户编号：{customer_no}, 订单编号：{order_no}, 订单金额：{total_amount}")

# 关闭连接
conn.close()

这个查询首先筛选出购买指定商品的记录，然后按客户和订单编号分组，最后只返回那些购买了两种商品的客户。