Leetcode力扣 MySQL数据库 1393 股票的资本损益

最新推荐文章于 2023-03-23 16:25:01 发布

ziko-1101

最新推荐文章于 2023-03-23 16:25:01 发布

阅读量121

点赞数

分类专栏： Leetcode MySQL数据库（VIP）题目及解答文章标签：数据库 leetcode mysql

本文链接：https://blog.csdn.net/m0_46458212/article/details/127616600

版权

通过SQL查询计算股票的资本损益，展示每支股票的收益或损失。例如，LeetCode股票收益8000美元，Corona Masks股票收益9500美元，而Handbags股票损失23000美元。

摘要由CSDN通过智能技术生成

1393 股票的资本损益

SQL架构

Create Table If Not Exists Stocks_1393 (stock_name varchar(15), operation ENUM('Sell', 'Buy'), operation_day int, price int);
Truncate table Stocks_1393;
insert into Stocks_1393 (stock_name, operation, operation_day, price) values ('Leetcode', 'Buy', '1', '1000');
insert into Stocks_1393 (stock_name, operation, operation_day, price) values ('Corona Masks', 'Buy', '2', '10');
insert into Stocks_1393 (stock_name, operation, operation_day, price) values ('Leetcode', 'Sell', '5', '9000');
insert into Stocks_1393 (stock_name, operation, operation_day, price) values ('Handbags', 'Buy', '17', '30000');
insert into Stocks_1393 (stock_name, operation, operation_day, price) values ('Corona Masks', 'Sell', '3', '1010');
insert into Stocks_1393 (stock_nam