CREATE TABLE Lessons (lesson_status_code VARCHAR)

How many lessons were in cancelled state?
SELECT COUNT(*) FROM Lessons WHERE lesson_status_code = "Cancelled"
SELECT COUNT(*) FROM "Lessons" WHERE "Cancelled" = "lesson_status_code"