List lesson id of all lessons taught by staff with first name as Janessa
select t1.lesson_id from lessons as t1 join staff as t2 on t1.staff_id = t2.staff_id where t2.first_name = "Janessa"
Intersect that with last name Sawayn and nickname containing letter 's'.
select t1.lesson_id from lessons as t1 join staff as t2 on t1.staff_id = t2.staff_id where t2.first_name = "Janessa" and t2.last_name = "Sawayn" and nickname like "%s%";