In which of the following scenarios is the DATE_ADD function the optimal date function to use? Select ALL that apply.
- To find values in the last 30 days
- To find values in the last month.
- To add or subtract a certain number of days from a given date
- To find values in a given week.
- To find values between the start of last month, and the end of the current month