Schema: CREATE TABLE files (duration VARCHAR)
Question: How many songs have 4 minute duration?
SQL: SELECT COUNT(*) FROM files WHERE duration LIKE "4:%"