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.