查询每个人连续成功4次 mysql的

DROP TABLE IF EXISTS test;
CREATE TABLE test (
Id int(11) NOT NULL AUTO_INCREMENT,
a varchar(255) DEFAULT NULL,
b varchar(255) DEFAULT NULL,
ctime varchar(255) DEFAULT NULL,
PRIMARY KEY (Id)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

#

Data for table "test"

#

/*!40000 ALTER TABLE test DISABLE KEYS /;
INSERT INTO test VALUES (1,'小王','成功','2017-03-01 00:00:00'),(2,'小王','成功','2017-03-02 00:00:00'),(3,'小王','成功','2017-03-01 00:00:00'),(4,'小王','成功','2017-03-02 00:00:00'),(5,'小李','成功','2017-03-03 00:00:00'),(6,'小张','失败','2017-03-04 00:00:00'),(7,'小李','失败','2017-03-05 00:00:00'),(8,'小红','失败','2017-03-06 00:00:00'),(9,'小张','失败','2017-03-07 00:00:00'),(10,'小红','成功','2017-03-08 00:00:00'),(11,'小李','成功','2017-03-05 00:00:00'),(12,'小红','成功','2017-03-08 00:00:00'),(13,'小红','成功','2017-03-08 00:00:00'),(14,'小红','成功','2017-03-08 00:00:00'),(15,'小红','成功','2017-03-08 00:00:00');
/!40000 ALTER TABLE test ENABLE KEYS */;

http://www.oschina.net/question/1264785_167198?sort=time