┌──────┬────────┬────────┐
│  id  │  date  |  sale  │
│      │        │        │

SELECT * FROM table WHERE table.date BETWEEN date('now', 'Weekday 1', '-21 days') AND date('now')