blob: 4c51fa70e96b932ab89082b6d8a1c1b1e45bdc36 [file] [log] [blame]
SELECT
yearweek(day) AS k,
count() AS c
FROM opensky
WHERE origin IN ('UUEE', 'UUDD', 'UUWW')
GROUP BY k
ORDER BY k ASC;