1 2 3 4 5 6 7
# mysql:skip # clickhouse:skip # glaredb:skip (the string_agg function is not supported) from tracks filter genre_id == 100 derive empty_name = name == '' aggregate {sum track_id, concat_array name, all empty_name, any empty_name}