This query correctly joins my two tables. I then want to use this newly formed table in another query as a subquery.

```
SELECT *
FROM players s JOIN player_data t
WHERE s.player_id = t.player_id

Is it possible to do smth like this:

SELECT MAX(e.height)
FROM (SELECT *
FROM players s JOIN player_data t
WHERE s.player_id = t.player_id) as e
GROUP BY e.height

```