# Subquery Placement Example
__*Where subquery are available*__
+ Planets that are larger in mass than Earth
+ Planets that are larger in mass than Earth or Mars
```
SELECT name FROM universe.planets
WHERE mass ~!@>@!~ (SELECT mass 
               FROM universe.planets
               WHERE name = 'Earth');

SELECT name from universe.planets
WHERE mass ~!@> ANY@!~ (SELECT mass
                  FROM universe.planets
                  WHERE name in ('Earth', 'Mars'));
```

------------------------------------------------------------
```
tidb> SELECT name FROM universe.planets
    -> WHERE mass > (SELECT mass 
    ->                FROM universe.planets
    ->                WHERE name = 'Earth');
+--------------------+
| name               |
+--------------------+
| Jupiter            |
| Saturn             |
| Uranus             |
| Neptune            |
| Proxima Centauri b |
+--------------------+
5 rows in set (0.00 sec)

tidb> SELECT name from universe.planets
    -> WHERE mass > ANY (SELECT mass
    ->                   FROM universe.planets
    ->                   WHERE name in ('Earth', 'Mars'));
+--------------------+
| name               |
+--------------------+
| Venus              |
| Earth              |
| Jupiter            |
| Saturn             |
| Uranus             |
| Neptune            |
| Proxima Centauri b |
+--------------------+
7 rows in set (0.00 sec)

```