SQL Interview Question | Capital Gain/Loss in Stocks (BUY vs SELL) | CTE vs CASE WHEN Solution

In this video, we solve a very common SQL interview problem:
✅ Calculate Capital Gain/Loss for each stock using BUY and SELL transactions.
You’ll learn 2 best approaches:
1️⃣ Using CTE (WITH clause) to separately sum BUY and SELL values
2️⃣ Using CASE WHEN to compute profit/loss in a single query (most efficient)
📌 Output: stock_name + capital_gain_loss
This question is asked in Data Analyst / SQL Developer / Product-based company interviews.
🔥 Topics Covered:
SQL CTE (WITH clause)
GROUP BY + SUM
CASE WHEN conditional aggregation
Join optimization
Interview-ready explanation
💡 Perfect for: Data Analyst, Business Analyst, SQL interviews, Placement prep
#leetcode #coding #databaseconcepts #sqlinterview #programming #technicalinterview #jobinterview #galgotiasuniversitynoida #noidainternationaluniversity #noida #jobinterview #freshers #dataanalysis #dataanalyst

Видео SQL Interview Question | Capital Gain/Loss in Stocks (BUY vs SELL) | CTE vs CASE WHEN Solution канала Vivek The Analyst