本文共 587 字，大约阅读时间需要 1 分钟。

题目：（中等）

标签：SQL

解法一：

SELECT DISTINCT S.stock_name,                IFNULL(T2.sell, 0) - IFNULL(T1.buy, 0) AS capital_gain_lossFROM Stocks AS S         LEFT JOIN     (SELECT stock_name,             SUM(price) AS buy      FROM Stocks      WHERE operation = 'Buy'      GROUP BY stock_name) AS T1 ON S.stock_name = T1.stock_name         LEFT JOIN     (SELECT stock_name,             SUM(price) AS sell      FROM Stocks      WHERE operation = 'Sell'      GROUP BY stock_name) AS T2 ON S.stock_name = T2.stock_name;

转载地址：https://dataartist.blog.csdn.net/article/details/110423075 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！