create table ten(a int);

insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

create table t1 (a int, b int) as select a as a, a as b from ten;

mysql> explain select * from ten where a > (select max(b) from t1 where t1.b <= ten.a);

+------+--------------------+-------+------+---------------+------+---------+------+------+----------------------------+

| id   | select_type        | table | type | possible_keys | key  | key_len | ref  | rows | Extra                      |

+------+--------------------+-------+------+---------------+------+---------+------+------+----------------------------+

|    1 | PRIMARY            | ten   | ALL  | NULL          | NULL | NULL    | NULL |   10 | Using where; Subqueries: 2 |

|    2 | DEPENDENT SUBQUERY | t1    | ALL  | NULL          | NULL | NULL    | NULL |   10 | Using where                |

+------+--------------------+-------+------+---------------+------+---------+------+------+----------------------------+

  Subquery #n

  Subquery #n1, #n2