+ 20

[SOLVED] SQL doesn't accept lower case answer?

Hello, this is under SQL and when I tried to run the test cases and they failed. The things I spotted different from my output and the correct output is mine are all lower case For example mine is 'broccoli soup' while the expected output is 'Broccoli Soup', may I know if anyone encountered this and how did you fix? Thank you very much!

1st May 2021, 2:57 AM
Lê Hữu Gia Nghi
Lê Hữu Gia Nghi - avatar
33 Réponses
+ 4
I’m angry about the same problem
2nd May 2021, 4:08 AM
Han Zhou
Han Zhou - avatar
+ 13
I think we can consider this a bug in the test data. I have reported it via in-app feedback, we can only hope SL fix it at some point. There is no simple way to convert the string to Title Case, certainly not beginner level.
1st May 2021, 6:09 AM
Tibor Santa
Tibor Santa - avatar
+ 9
Lê Hữu Gia Nghi, Tibor Santa I'm not 100% familiar with the particular problem that's being spoken about. Nevertheless, I'm going to go by what's being said and attempt to wing it anyway. Would the logic noted in the code below not be helpful with what you're/she's trying to do? https://code.sololearn.com/cL68j1V9JkdZ
1st May 2021, 6:55 AM
Fox
Fox - avatar
+ 7
Tibor Santa I guess it was a good thing that I opened with those first couple of sentences in my answer then, eh?
1st May 2021, 1:20 PM
Fox
Fox - avatar
+ 5
Lê Hữu Gia Nghi In starting when they have introduced SQL course then everything was working fine but now our completed task is also not working.
1st May 2021, 3:44 AM
A͢J
A͢J - avatar
+ 4
Actually, SQL is case insensitive language so we can use both lower & upper case . But in sololearn it may be followed due to it is not completely SQL server.. Lê Hữu Gia Nghi Mail to the sololearn.
1st May 2021, 3:01 AM
Sâñtôsh
Sâñtôsh - avatar
+ 4
You can use the InitCap() function to pass in arguments. SELECT InitCap(firstname) AS firstname, grade FROM students WHERE grade >= 88
3rd May 2021, 1:33 AM
Shawn
Shawn - avatar
+ 2
hhello, thanks for your answer, I agree that sql is insensitive :( but for sololearn would there be a way to fix this? thank you!
1st May 2021, 3:02 AM
Lê Hữu Gia Nghi
Lê Hữu Gia Nghi - avatar
+ 2
Even I am facing the same problem.
1st May 2021, 6:56 AM
Mohit Kumar
+ 2
Fox true that something like your example can work to manipulate strings, but that is totally offtopic for a beginner practice quiz. The task is supposed to test the understanding of ORDER BY and LIMIT clauses. String functions are not even mentioned at that point.
1st May 2021, 8:12 AM
Tibor Santa
Tibor Santa - avatar
+ 2
I faced the same situation today in Zoo project. I know my code is correct but it gives me errors althou it outputs the same result but without camelcases. This is my code : /* name - "Slim", type - "Giraffe", country_id - 1 */ INSERT INTO Animals VALUES('Slim', 'Giraffe', 1); SELECT name, type, country FROM Animals INNER JOIN Countries ON Animals.country_id = Countries.id ORDER BY country;
1st May 2021, 9:11 AM
Valentin SURMEI
Valentin SURMEI - avatar
+ 2
Han Zhou Show your anger on info@sololearn.com
2nd May 2021, 6:48 AM
A͢J
A͢J - avatar
+ 2
I used InitCap() as Shawn Blackman suggested but, unfortunately, in Zoo project 'USA' is all capitals opposite to, let's say 'India'. So I'll wait for fixing... Cheers!
3rd May 2021, 5:58 AM
IvanaGoSt
IvanaGoSt - avatar
+ 2
The issue still persists as you can see in this printscreen http://prntscr.com/12gqyb0 I have sent an email to info@sololearn.com to ask them to fix it since we can't get our certification as long as lesson 28 is not solved.
4th May 2021, 8:12 AM
Valentin SURMEI
Valentin SURMEI - avatar
+ 1
Same here with the 3 cert projects
1st May 2021, 7:37 AM
Tobias Rauer
Tobias Rauer - avatar
+ 1
The issue also appears in SQL - End of module project 28
1st May 2021, 8:47 AM
Tobias Kahnis
Tobias Kahnis - avatar
+ 1
The output is case sensitive...
2nd May 2021, 3:51 PM
Sanjay Kamath
Sanjay Kamath - avatar
+ 1
I have the same problem with zoo and cake project
2nd May 2021, 5:03 PM
Sabrina B.
Sabrina B. - avatar
+ 1
The issue seems to be fixed by devs
3rd May 2021, 1:50 PM
Akula Dheeraj
Akula Dheeraj - avatar
+ 1
Awesome!
3rd May 2021, 2:18 PM
Shawn Blackman
Shawn Blackman - avatar