Review
So you think you can count?
Rounding functions and more
21. Numeric functions: SQRT()
Review and practice

Instruction

Perfect!

The last function we want to introduce is SQRT(x), which calculates the square root of x (that is √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 this function a go as well.

Exercise

A nasty curse in our game changes a character's strength to its square root for a few minutes.

Show each character's name, strength, and the square root of their strength. Name the column CursedStrength.

Stuck? Here's a hint!

You need SQRT(Strength).