查询排名前三数据含并列

CREATE TABLE `te` (
  `name` char(20) CHARACTER SET utf8 DEFAULT NULL,
  `lesson` char(20) CHARACTER SET utf8 DEFAULT NULL,
  `mark` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('a', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('b', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('c', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('d', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('e', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('f', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('g', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('h', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('i', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('g', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('k', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('l', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('m', 'Math', '50');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('n', 'Math', '69');
INSERT INTO `mysql`.`te` (`name`, `lesson`, `mark`) VALUES ('o', 'Math', '95');

sql：

SELECT * from te a WHERE 
(SELECT COUNT(*) from te b where a.mark<b.mark) <3