Subqueries can appear in:

• WHERE clause (filter rows)
• FROM clause (treat subquery as a derived table)

SELECT DISTINCT courseId
FROM section
WHERE semester = 'Fall' AND year = 2017
  AND courseId IN (
    SELECT courseId
    FROM section
    WHERE semester = 'Spring' AND year = 2018
  );