test2

CREATE TABLE Renewable_Energy_Devices3 (
    device_id NVARCHAR(26) PRIMARY KEY,
    device_status INT CHECK (device_status >= 0 AND device_status <= 6)
    device_power DECIMAL(10)
);

INSERT INTO Renewable_Energy_Devices (device_id, device_status, device_power)
VALUES
('12345678901234567890123456',  0,  1000),
('22345678901234567890123456',  1,  1000),
('32345678901234567890123456',  2,  1000),
('42345678901234567890123456',  3,  1000),
('52345678901234567890123456',  4,  1000),
('62345678901234567890123456',  0,  1000),
('72345678901234567890123456',  1,  1000),
('82345678901234567890123456',  2,  1000),
('92345678901234567890123456',  3,  1000),
('10234567890123456789012345',  4,  1000),
('11234567890123456789012345',  0,  1000),
('12234567890123456789013456',  1,  1000),
('13234567890123456789012456',  2,  1000),
('14234567890123456789012345',  3,  1000),
('15234567890123456789012345',  4,  1000),
('16234567890123456789012345',  0,  1000),
('17234567890123456789012356',  1,  1000),
('18234567890123456789012345',  2,  1000),
('19234567890123456789012345',  3,  1000),
('20234567890123456789012345',  4,  1000),
('21234567890123456789012345',  0,  1000),
('22234567890123456789012345',  1,  1000),
('23234567890123456789012345',  2,  1000),
('24234567890123456789012345',  3,  1000),
('25234567890123456789012345',  4,  1000),
('26234567890123456789012345',  0,  1000),
('27234567890123456789012345',  1,  1000),
('28234567890123456789012345',  2,  1000),
('29234567890123456789012345',  3,  1000),
('30234567890123456789012345',  4,  1000),
('31234567890123456789012345',  0,  1000),
('32234567890123456789012345',  1,  1000),
('33234567890123456789012345',  2,  1000),
('34234567890123456789012345',  3,  1000),
('35234567890123456789012345',  4,  1000),
('36234567890123456789012345',  0,  1000),
('37234567890123456789012345',  1,  1000),
('38234567890123456789012345',  2,  1000),
('39234567890123456789012345',  3,  1000),
('40234567890123456789012345',  4,  1000),
('41234567890123456789012345',  0,  1000),
('42234567890123456789012345',  1,  1000),
('43234567890123456789012345',  2,  1000),
('44234567890123456789012345',  3,  1000),
('45234567890123456789012345',  4,  1000);