saved_queries: 22-23-catalog
This data as json
| name | sql | author_id |
|---|---|---|
| 22-23-catalog | select quarter || ' ' || year as term ,department ,course_number ,title ,instructor ,credits from courses where department = :department and (case :level when '500' then course_number like '5%%' when '400' then course_number like '4%%' when '300' then course_number like '3%%' when '200' then course_number like '2%%' when '100' then course_number like '1%%' else true end) and quarter||year in ('fall2022', 'winter2023', 'spring2023', 'summer2023') | mattmatt |