Which Codémons are stronger than average? You could run SELECT AVG(level) FROM codemon (11.5), then type that number into a second query. Or you can let SQL do both steps at once:
↗️
Loading editor...
↶
↷
The query in parentheses is a subquery. It runs first, returns a single value (11.5), and the outer query uses that value exactly as if you had typed it. Four Codémons are above average.
Why not just type 11.5?
Because the average changes as soon as the data changes. The subquery stays correct forever; the hard-coded number is wrong after the first new Codémon.