I need help with running a SQL on CARTO.
I want to generate a dot density similar to the link here.
The second portion of the SQL code deletes the
cartodb column and nothing changes on the map.
SELECT ST_TRANSFORM(cynthia.by_state_population(the_geom,DP0080005/100),3857) as the_geom_webmercator, 'DP0080005' as ethnicity, 1 as t from tract_2010census_dp1_simple