what code be put in the sql for all purchases in last 30 days?

Here is another example for you to try - this query will tell us what day of the week our purchases were made on: SELECT AcctNum, CampNum, WEEKDAYNAME (WEEKDAY (PURCHDATE)) AS DayofWeek FROM PURCHASE; Write a query to return all the details for purchases in the past 30 days. You'll notice that there are no purchases fitting this criterion in the database. You should use the DataSheet View of the PURCHASE table to add a purchase within the last 30 days, so that you can test your query. SAVE THIS QUERY IN THE DATABASE AS "09_ALL_PURCHASES_LAST_30_DAYS" ation Operations: SUM(), COUNT(), AVG() . FORMAT Aside from basic attributes (i.e. column/ field names) you can also use the following aggregation / summarization operators in your queries