in_data = {
'may 2017': [24, 26, 15, 10, 15, 19, 10, 1, 4, 7, 7, 7, 12, 14, 17, 8, 9, 19, 21, 22, 11, 15, 19, 23, 15, 21, 16, 13, 25, 17, 19],
'may 2018': [20, 27, 23, 18, 24, 16, 20, 24, 18, 15, 19, 25, 24, 26, 19, 24, 25, 21, 17, 11, 20, 21, 22, 23, 18, 20, 23, 18, 22, 23, 11]
}
for im in in_data.keys():
print(im, len(list(filter(lambda x: x>=22 and x <=26, in_data[im]))))
may 2017 5
may 2018 13
Но он сильно греться начал, что при работе когда сильно гружуРазумеется, так и должно быть.
CREATE TABLE MYTABLE (
ID BIGINT NOT NULL CONSTRAINT PK_MYTABLE PRIMARY KEY,
CLIENT BIGINT NOT NULL CONSTRAINT FK_MYTABLE_CLIENT FOREIGN KEY REFERENCES CLIENTS(ID),
EMAIL NVARCHAR(100) NOT NULL CONSTRAINT UQ_MYTABLE_EMAIL UNIQUE,
ACTIVE BIT NOT NULL CONSTRAINT DF_MYTABLE_ACTIVE DEFAULT (1)
)