mysql如何查上周数据

Question

My sql如何查询上周一周的数据，就是当前日期的上一周（周一到周日的数据量）my sql语句时间不会

```sql
SELECT
    date_format(
        `sf_fumian_data`.`huizongriqi`,
        '%x年-第%v周'
    ) AS `当前周`,
    count(`sf_fumian_data`.`url`) AS `明细数据`,
    `sf_fumian_data`.`name` AS `公司名称`,
    round(
        (
            count(`sf_fumian_data`.`url`) / 7
        ),
        2
    ) AS `上周日均`
FROM
    `sf_fumian_data`
WHERE
    (
        `sf_fumian_data`.`huizongriqi` BETWEEN (
            (
                curdate() - INTERVAL (dayofweek(curdate()) - 1) DAY
            ) - INTERVAL 7 DAY
        )
        AND (
            curdate() - INTERVAL (dayofweek(curdate()) - 1) DAY
        )
    )
GROUP BY
    `sf_fumian_data`.`name`

```

Answer 1

查询上周的周一（星期一）：
select subdate(curdate(),date_format(curdate(),'%w')+6)
查询上周的周日（星期日）：
select subdate(curdate(),date_format(curdate(),'%w'))

有帮助的话，请点采纳~