CREATE TABLE IF NOT EXISTS STUDY (
	ID integer primary key autoincrement
);

CREATE TABLE IF NOT EXISTS SERIE (
	ID integer primary key autoincrement,
	STUDY_ID int,
	FOREIGN KEY(STUDY_ID) REFERENCES STUDY(ID));
CREATE INDEX IF NOT EXISTS STUDYID_INDEX ON SERIE (STUDY_ID);

SELECT SE.STUDY_ID, COUNT(SE.ID) FROM SERIE SE GROUP BY SE.STUDY_ID order by SE.STUDY_ID ASC limit 1000

SELECT SE.STUDY_ID, COUNT(SE.ID) FROM SERIE SE GROUP BY SE.STUDY_ID order by SE.STUDY_ID DESC limit 1000