In Your case any value will work (it builds array of 1’s , based on WHEN condition). I can used binding variable v, but in this case not needed and will reduce memory. You can put expression in projection and see what it produces.
(SELECT RAW COUNT(1) FROM d.skills AS sk WHERE sk.name IN ["C Programming","C++"]) matches;
FROM default AS d
ORDER BY matches DESC;