mysql - mysql 为每个客户返回一行

Question

我试图弄清楚如何为每个客户打印一行。现在当我运行时

SELECT email_address, sum(quantity * item_price), sum(discount_amount * quantity)
FROM customers JOIN order_items
ORDER BY sum(quantity * item_price)

我只得到第一个客户。就价格而言，一切都是正确的，但它只打印第一个客户。我需要表中的所有客户。有什么建议么？我需要加入任何 table 吗？它似乎在没有连接表的情况下工作。哦，我还需要它根据 item_price 降序排列。任何帮助深表感谢。提前致谢

Answer 1

尝试这样:

SELECT email_address, sum(quantity * item_price), sum(discount_amount * quantity)
FROM customers JOIN order_items on customers.id= order_items.id
GROUP BY (email_address)
ORDER BY sum(quantity * item_price)