Given the following table:
EMPLOYEE
EMPID NAME INSTRUMENT
— ————— —–
1 Jagger, Mick 01
2 Richards, Keith 02
3 Wood, Ronnie 02
4 Watts, Charlie 03
5 Jones, Darryl 04
6 Leavell, Chuck 05
If the following query is executed:
SELECT name,
CASE WHEN instrument = ’01’ THEN ‘HARMONICA’
WHEN instrument = ’02’ THEN ‘GUITAR’
WHEN instrument = ’03’ THEN ‘DRUMS’
ELSE ‘UNKNOWN’
END AS instrument
FROM employee
What will be the results?

A.
NAME INSTRUMENT
————— ——–
Jagger, Mick HARMONICA
Richards, Keith GUITAR
Wood, Ronnie GUITAR
Watts, Charlie DRUMS
Jones, Darryl ERROR
Leavell, Chuck ERROR

B.
NAME INSTRUMENT
—————— ——–
Jagger, Mick HARMONICA
Richards, Keith GUITAR
Wood, Ronnie GUITAR
Watts, Charlie DRUMS
Jones, Darryl 04
Leavell, Chuck 05

C.
NAME INSTRUMENT
—————— ——–
Jagger, Mick HARMONICA
Richards, Keith GUITAR
Wood, Ronnie GUITAR
Watts, Charlie DRUMS
Jones, Darryl UNKNOWN
Leavell, Chuck UNKNOWN

D.
NAME INSTRUMENT
—————— ——–
Jagger, Mick HARMONICA
Richards, Keith GUITAR
Wood, Ronnie GUITAR
Watts, Charlie DRUMS