WITH durations AS (
select section_id, (CAST (
SUBSTRING (time_end from 1 FOR 2) AS INT) * 60 +
CAST (SUBSTRING (time_end from 4 FOR 2) AS INT)) AS END,
(CAST (SUBSTRING (time_start from 1 FOR 2) AS INT) * 60 +
CAST (SUBSTRING (time_start from 4 FOR 2) AS INT)) AS start,
instruct_name AS NAME
from myc_schedule
)

select distinct NAME, term, durations.start, durations.end
from myc_section join durations
ON myc_section.id = durations.section_id
WHERE durations.start > 660 AND durations.end < 1020
AND NAME NOT LIKE '%TBA%'
AND NAME NOT LIKE '%TRENT UNIVERSITY%'
AND NAME NOT LIKE ''
order BY NAME, term;