Ordonner des données selon un champ d'une autre table

CREATE TABLE IF NOT EXISTS Tables(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name VARCHAR NOT NULL,
    UNIQUE (name)
);

CREATE TABLE IF NOT EXISTS CrudeData(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    cow INTEGER NOT NULL,
    date DATE NOT NULL,
    prod REAL NOT NULL, -- L
    cons REAL NOT NULL, -- kg
    lact INTEGER NOT NULL,
    day INTEGER NOT NULL,
    UNIQUE (cow, date)
);

INSERT OR IGNORE INTO Tables (name) VALUES ('CrudeData');

CREATE TABLE IF NOT EXISTS DifferencedData(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    source INTEGER NOT NULL, -- The corresponding line in CrudeData table
    prod REAL NOT NULL,
    degree INTEGER, -- How many times data have been differenced
    FOREIGN KEY(source) REFERENCES CrudeData(id),
    UNIQUE (source, degree)
);

INSERT OR IGNORE INTO Tables (name) VALUES ('DifferencedData');

SELECT prod FROM DifferencedData WHERE degree = 1 AND source IN (SELECT id FROM CrudeData WHERE cow = 1)

SELECT prod FROM DifferencedData WHERE degree = 1 AND source IN (SELECT id FROM CrudeData WHERE cow = 1) ORDER BY CrudeData.date

SELECT DifferencedData.prod 
FROM DifferencedData 
INNER JOIN CrudeData 
    ON DifferencedData.source = CrudeData.id 
WHERE DifferencedData.degree = 1 AND CrudeData.cow = 1 
ORDER BY CrudeData.date;