-- Comments start with "--", "#", or ";".
-- Section names are used as file names.
[logfiles-per-device]
SELECT
    serial,
    COUNT(*)
FROM
    (
        SELECT DISTINCT
            serial,
            filename
        FROM
            logs
    )
GROUP BY
    serial
ORDER BY
    serial
;
[errors-per-device]
SELECT
    serial,
    fixedmsg,
    COUNT(*)
FROM
    logs
WHERE
    loglevel='Error'
GROUP BY
    serial,
    fixedmsg
ORDER BY
    fixedmsg,
    serial
;
--
-- and so on