# Advantages Of Subquery

+ Subquery often makes `SQL` statements easier to read
```
tidb> SELECT 
   -> table_schema, table_name, table_rows
   -> FROM information_schema.tables
   -> WHERE table_rows ~!@>@!~ (
   ->    SELECT ~!@AVG(table_rows)@!~ FROM information_schema.tables);
+--------------+-----------------------------+------------+
| table_schema | table_name                  | table_rows |
+--------------+-----------------------------+------------+
| test         | auto_random_t1_clustered    |    1048576 |
| test         | auto_random_t2_nonclustered |    1048576 |
| world        | city                        |       4079 |
+--------------+-----------------------------+------------+
```

------------------------------------------------------------