...
      my $sql= "SELECT name,city, COUNT(*) AS rows 
                  FROM myfile.csv
                  WHERE myfile.csv >= CURDATE() - INTERVAL(6) DAY 
                  AND myfile.csv  < CURDATE() + INTERVAL(1) DAY";
...

##</code><code>##

BD::CSV::st execute failed: Can't find table containing column named 'interval' at /Library/Perl/5.18/SQL/Statement/Function.pm line 212.
 [for Statement "SELECT name,city COUNT(*) AS rows 
                  FROM file.csv
                  WHERE mydate >= CURDATE() - INTERVAL(6) DAY 
                  AND mydate < CURDATE() + INTERVAL(1) DAY"] at file.pl line 94, <GEN1> line 2.
DBD::CSV::st execute failed: Can't find table containing column named 'interval' at /Library/Perl/5.18/SQL/Statement/Function.pm line 212.
 [for Statement "SELECT name,city, COUNT(*) AS rows 
                  FROM file.csv
                  WHERE mydate >= CURDATE() - INTERVAL(6) DAY 
                  AND mydate < CURDATE() + INTERVAL(1) DAY"] at file.pl line 94, <GEN1> line 2.