Find Stocks with Increasing Prices for 3 or More Consecutive Days Using SQL скачать в хорошем качестве

Find Stocks with Increasing Prices for 3 or More Consecutive Days Using SQL

In this SQL problem-solving session, we analyze stock price trends to identify stocks that have increased in price for three or more consecutive days. Using real-world stock market data, we leverage SQL techniques such as window functions (LAG, ROW_NUMBER), CTEs (Common Table Expressions), and filtering strategies to efficiently detect trends in stock price movements. This session is perfect for data analysts, SQL learners, and financial analysts who want to enhance their skills in time-series analysis, pattern recognition, and database querying with SQL. 🔹 Key Topics Covered: ✅ Identifying stock trends using LAG() and ROW_NUMBER() ✅ Using CTEs for structured querying ✅ Grouping and filtering stock data efficiently 📌 Table Creation & Insertion Script: CREATE TABLE stocks ( stock_name VARCHAR(20), stock_date DATE, stock_price DECIMAL(10, 2) ); INSERT INTO stocks(stock_name, stock_date, stock_price) VALUES ('IRCTC','2024-10-31',821.3), ('IRCTC','2024-10-30',839.4), ('IRCTC','2024-10-29',824.85), ('IRCTC','2024-10-28',821.05), ('IRCTC','2024-10-25',812.1), ('IRCTC','2024-10-24',830.15), ('SBI','2024-11-07',860.2), ('SBI','2024-11-06',854.8), ('SBI','2024-11-05',849.2), ('SBI','2024-11-04',829.85), ('SBI','2024-11-01',821.2), ('Cochin Shipyard','2024-11-07',1514), ('Cochin Shipyard','2024-11-06',1536.9), ('Cochin Shipyard','2024-11-05',1496.35), ('Cochin Shipyard','2024-11-04',1503.45), ('Cochin Shipyard','2024-11-01',1527.25), ('Cochin Shipyard','2024-10-31',1497.2), ('Grasim','2024-10-24',2666.7), ('Grasim','2024-10-23',2633.2), ('Grasim','2024-10-22',2655.35), ('Grasim','2024-10-21',2718.25), ('Grasim','2024-10-18',2760.95); 🔥 Don't forget to like, share, and subscribe for more SQL tutorials! 🚀 #SQL #DataAnalysis #StockMarket #SQLQueries #TimeSeriesAnalysis #SQLWindowFunctions #FinancialData #LearnSQL #SQLForBeginners #DataScience