• Home
• com.github.javadev
• leetcode-in-java
• 1.10
• source code
• script.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

g1301_1400.s1393_capital_gainloss.script.sql Maven / Gradle / Ivy

# Write your MySQL query statement below
# #Medium #Database #SQL_I_Day_9_Control_of_Flow
# #2022_05_24_Time_457_ms_(79.39%)_Space_0B_(100.00%)
SELECT
    stock_name, 
    SUM(IF (operation = 1, price, -1 * price)) AS capital_gain_loss
FROM
    Stocks
GROUP BY
    stock_name
ORDER BY
    operation_day asc;