# 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}