Keep Only the 2025 Targets
MediumDescription
Only the 2025 sales targets are still needed. Replace monthly_targets with a table
that holds just the 2025 rows, in this order:
- rename
monthly_targetstoold_targets - create a new
monthly_targetsfrom the 2025 rows ofold_targets - drop
old_targets
Each month is the first day of its month.
Finish with this query:
CodeSELECT month, target_amount FROM monthly_targets ORDER BY month;
Tables
| monthly_targets |
|---|
| month (PK) |
| target_amount |