SELECT
    telemetry_id
    JSON_OBJECT("ScheduledQueriesList", JSON_OBJECT("n", example_telemetry.name)),
    MIN(DATE),
    MAX(DATE)
FROM
    example_telemetry
GROUP BY
    example_telemetry.telemetry_id[/code]

[b]Aliasing should be performed USING AS[/b]
[code]SELECT
    table_one.column_a AS column_one,
    table_one.column_b AS column_two
FROM
    tableOne AS table_one