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