Select Code to Download

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

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.p
+l line 94, <GEN1> line 2.