MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE stock_prices (Country_Exchange_Code VARCHAR(2), Stock_Code VARCHAR(4), Date DATE, Close FLOAT);
INSERT INTO stock_prices VALUES
("T", "1301",   '2019-10-29',   75.2),
("T", "1301",   '2019-10-30',   76.6),
("T", "1301",   '2019-10-31',   77.6),
("T", "1301",   '2019-11-01',   77.2),
("T", "1332",   '2019-10-29',   52.5),
("T", "1332",   '2019-10-30',   49.7),
("T", "1332",   '2019-10-31',   50.8),
("T", "1332",   '2019-11-01',   50.4),
("T", "1333",   '2019-10-29',   13.9),
("T", "1333",   '2019-10-30',   13.8),
("T", "1333",   '2019-10-31',   14.3),
("T", "1333",   '2019-11-01',   14.4);
WITH
    cte AS (SELECT '1332')    
SELECT * FROM stock_prices
WHERE Country_Exchange_Code = 'T' AND Stock_Code IN (cte);
Unknown column 'cte' in 'where clause'

WITH
    cte AS (SELECT '1332')    
SELECT * FROM stock_prices
WHERE Country_Exchange_Code = 'T' AND Stock_Code IN (TABLE cte);


Country_Exchange_Code
Stock_Code
Date
Close


T
1332
2019-10-29
52.5

T
1332
2019-10-30
49.7

T
1332
2019-10-31
50.8

T
1332
2019-11-01
50.4

Country_Exchange_Code	Stock_Code	Date	Close
T	1332	2019-10-29	52.5
T	1332	2019-10-30	49.7
T	1332	2019-10-31	50.8
T	1332	2019-11-01	50.4