ActiveRecord与日期相关的查询; MySQL与PostgreSQL

I have a database of records that I want to select the most recent week of days and group by the day to get the count per day on these records. If I was writing the MySQL query manually, I'd start with something like:I have a database of records that I want to sel