Lesson $29$: CASE

You can use a CASE statement to return certain values when certain scenarios are true.

A CASE statement takes the following form:

CASE WHEN THEN WHEN $*$ second thing is true$*$ THEN

ELSE END

For example, in order to return the number of legs for each row in friends$\_$of$\_$pickles, you could run:

SELECT $*,$

CASE WHEN species $=$ 'human' THEN $2$ ELSE $4$ END AS num$\_$legs

FROM friends$\_$of$\_$pickles;

Can you return the results with a column named sound that returns "talk" for humans, "bark" for dogs, and "meow" for cats?