Carlo Piovesan

@carlo.piovesan.io

1093 Followers 192 Following

Compiling @duckdb

FROM (SELECT count(*) as c, array_agg(DISTINCT title_no_albumversie(titel)) as list, artiest, any_value(jaar) as j, min(positie), max(positie) as p FROM top2000 WHERE positie <= 2000 GROUP BY artiest) WHERE c =4 AND length(list) =1 AND NOT artiest ILIKE '% & %' AND NOT artiest ILIKE '% ft. %' ORDER BY p LIMIT 40; --- DuckDB table result of aggregation by artist to find a list of its songs to ever finish in top 2000 in the last 4 years, then filter BY same song AND order by max position
Mosaic of a duck bathing in the Nile river