Schema: CREATE TABLE Lessons (lesson_status_code VARCHAR)
Question: How many lessons were in cancelled state?
SQL: SELECT COUNT(*) FROM Lessons WHERE lesson_status_code = "Cancelled"