-- This query is an example of using a correlated subquery
-- within the select clause

use studentdb;

select sectid, prof, (
  select title
  from course
  where cid = (
    select courseid
    from section
    where sectid = s.sectid
  )
) as title
from section s
;