my $sql = "SELECT name, city, COUNT(*) 
           FROM file.csv
           WHERE ((mydate >= ?) AND (mydate < ?))
           OR    ((mydate >= ?) AND (mydate < ?))
           GROUP BY name,city
          ";