saved_queries: class_time_schedule
This data as json
| name | sql | author_id |
|---|---|---|
| class_time_schedule | select department ,course_number ,title ,max(year) as last_offered ,group_concat(distinct quarter) as quarters_offered 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 (case when :most_recently is not null then year >= :most_recently else true end) group by department ,course_number ,title | mattmatt |