Where does it mention support for subselects ?

If you have 2 date ranges then try

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