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%";
What are the the lesson ids of all staff taught by Janessa Sawayn whose nickname has the 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 % '' ;
select t1 . lesson_id from lessons as t1 join staff as t2 on t1 . staff_id = t2 . staff_id where t2 . first_name = value and t2 . last_name = value and nickname like value
What are the the lesson ids of all staff taught by Janessa Sawayn whose nickname has the letter s ?