mysql 编写一个查询来确定有多少产品已售出并获利

zbq4xfa0 于 2022-12-03 发布在 Mysql

关注(0)|答案(2)|浏览(110)

我对SQL很陌生，我有三个表，事务，产品和客户，我想知道有多少产品卖出了利润。

SELECT t.product_id, p.id,  sum(t.total_price / t.quantity) - p.price As profit 
From transactions as t , products As p
INNER JOIN transactions
on t.product_id = p.id
GROUP by t.product_id

我的交易数据表中只有总价数据行。我应该将total_price除以quantity还是 *？我的全部查询如何？

mysql

来源：https://stackoverflow.com/questions/74656297/write-a-query-to-determine-how-many-product-have-been-sold-with-profit

2条答案

按热度按时间

sr4lhrrt1#

SELECT t.product_id,sum(t.total_price / t.quantity - p.price) as profit
  FROM transactions as t
     INNER JOIN product as p on t.id = p.id
       GROUP by t.product_id
         order by t.product_id

你能试试这边吗

赞(0）回复(0）举报 2022-12-03

pjngdqdw2#

SELECT t.product_id,sum(t.total_price / t.quantity - p.price) as profit, 
  count(t.quantity) as sold_count
    FROM transactions as t
      INNER JOIN product as p on t.id = p.id
        GROUP by t.product_id
          order by t.product_id

赞(0）回复(0）举报 2022-12-03

我来回答

mysql 编写一个查询来确定有多少产品已售出并获利

2条答案

相关问题

热门标签

最新问答