Table 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"