+ 1

SQL cakes challenge does not work

I wrote out the code and the names and calories are being displayed, but they're being pushed into all lower case and the challenge marked that incorrect. SQL is supposed to be case insensitive so I have no idea what's going on.

1st May 2021, 12:05 AM
Mark Maurer
Mark Maurer - avatar
2 Antworten
0
You can use the InitCap() function. It worked for me. It’s a workaround until the bugs are squashed😀 https://oraclesql.in/initcap/
2nd May 2021, 5:21 PM
Shawn Blackman
Shawn Blackman - avatar
0
SELECT name, calories FROM cakes ORDER BY calories LIMIT 3;
5th Oct 2021, 12:53 PM
Fatemeh Afsahhosseini
Fatemeh Afsahhosseini - avatar