Hello. I'm trying to create a query to sum the total quantity for the last 7 days. I also want another column to sum another total quantity for the last 28 days. Is that even possible? Below is my query:
