Choose Category
CREATE VIEW Today AS ( SELECT * FROM SYS_CALENDAR.Calendar WHERE SYS_CALENDAR.Calendar.calendar_date = DATE );
SELECT a2.week_of_calendar, SUM(a1.price) FROM Sales a1, SYS_CALENDAR.CALENDAR a2, Item a3, Class a4, TODAY a5 WHERE a1.calendar_date=a2.calendar_date AND (a2.week_of_calendar=a5.week_of_calendar OR a2.week_of_calendar=a5.week_of_calendar - 1 OR a2.week_of_calendar=a5.week_of_calendar - 52 OR a2.week_of_calendar=a5.week_of_calendar - 53 ) AND a1.itemID=a3.itemID AND a3.classID=a4.classID AND a4.classDesc=’Women’s cosmetics’ GROUP BY a2.week_of_calendar ORDER BY a2.week_of_calendar