ADVANCED SQL PART 2

Опубликовано: 09 Февраль 2026
на канале: Master SQL with Harshit Bhadiyadra

261

-----------------ADVANCED ANALYTICAL FUNCTIONS
----------------------------------------------------------------------------------------------------------
CREATE TABLE STOCK_PRICES
(
STOCK_SYMBOL VARCHAR(10),
TRADE_DATE DATE,
OPEN_PRICE DECIMAL(10,2),
CLOSE_PRICE DECIMAL(10,2)
)

--INSERT INTO STOCK_PRICES VALUES('ACME','2023-04-01',100.00,102.50)
--INSERT INTO STOCK_PRICES VALUES('ACME','2023-04-02',103.00,101.75)
--INSERT INTO STOCK_PRICES VALUES('ACME','2023-04-03',102.25,104.00)
--INSERT INTO STOCK_PRICES VALUES('BXYZ','2023-04-01',50.00,51.25)
--INSERT INTO STOCK_PRICES VALUES('BXYZ','2023-04-02',51.50,52.00)
--INSERT INTO STOCK_PRICES VALUES('BXYZ','2023-04-03',51.75,50.50)

SELECT * FROM STOCK_PRICES

--------------------------------------CORRELATED SUBQUERIES
----------------------------------------------------------------------------------------------------------
CREATE TABLE ORDERS75
(
ORDER_ID INT PRIMARY KEY,
CUSTOMER_ID INT,
ORDER_DATE DATE,
TOTAL_AMOUNT DECIMAL(10,2)
)

--INSERT INTO ORDERS75 VALUES(1,1,'2023-03-01',100.00)
--INSERT INTO ORDERS75 VALUES(2,1,'2023-03-15',200.00)
--INSERT INTO ORDERS75 VALUES(3,2,'2023-03-20',150.00)
--INSERT INTO ORDERS75 VALUES(4,2,'2023-04-01',300.00)

--INSERT INTO ORDERS75 VALUES(5,1,'2023-03-10',150.00)

--INSERT INTO ORDERS75 VALUES(6,2,'2023-03-24',200.00)

SELECT * FROM ORDERS75
ORDER BY CUSTOMER_ID,ORDER_DATE