SELECT referencia,zona,dormitorios, count(*) as totales FROM casa WHERE dormitorios >= colname GROUP BY zona