---

SELECT MIN(num), MAX(num), COUNT(*),
       MAX(num) - MIN(num) + 1 - COUNT(*) AS missing
FROM clean;

SELECT period, MIN(num), MAX(num), COUNT(*),
       MAX(num) - MIN(num) + 1 - COUNT(*) AS missing
FROM clean
GROUP BY period
ORDER BY period;