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