By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE course_subsections (ID, added);
✓
INSERT INTO course_subsections VALUES
(1, '2022-05-15'), (1, '2022-05-30'),
(2, '2022-06-01'), (2, '2022-07-31');
✓
SELECT ID,
CAST(JulianDay(MAX(added)) - JulianDay(MIN(added)) AS INTEGER) AS num_days_passed
FROM course_subsections
GROUP BY ID
ORDER BY num_days_passed DESC;
| ID | num_days_passed |
|---|---|
| 2 | 60 |
| 1 | 15 |