Re^5: DBI INTERVAL Error

[poj]

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
          ";

poj