Revision
So you think you can count
Round and other functions
22. Function sqrt
Revision and practice

Instruction

Perfect. The last function we want to introduce is sqrt(x), which calculates the square root of x (√x).

SELECT sqrt(25);

The square root of 25 is 5 and this is the result we'll get from the above query.

Let's give it a try again.

Exercise

A nasty curse in our game changes your strength to its square root for a few minutes. Show each character's name, strength and calculate the square root of strength for each of them.

Console

Code editor

Result

TableConsole