SCHEMA:
CREATE TABLE Lessons (lesson_status_code VARCHAR)
USER:
How many lessons were in cancelled state?

QUERY:
SELECT COUNT(*) FROM Lessons WHERE lesson_status_code = "Cancelled"