SQL Interview Question | Capital Gain/Loss in Stocks (BUY vs SELL) | CTE vs CASE WHEN Solution скачать в хорошем качестве

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