Selecting Multiple Columns in SQL

Question

I Have been solving the sololearn sql chalanges in the lessons the question was Select multiple columns from products table and here is what I tried so far but it didn't work is there something wrong inside my query:
SELECT ProductName,ProductionDate,
ExpirationDate FROM Products;

Answer 1

I can see that you are at this lesson:

https://www.sololearn.com/learn/SQL/1852/

I am going to try now, will be back in 1 sec.

It is case sensitive when comparing output.

https://www.sololearn.com/post/1064943/?ref=app

I'll write to SoloLearn to report this. Thanks for your question.

Answer 2

Abdalla Moha there is no error in your code . i am also facing the problem .
We can't do code coaches of sql right now due to a bug.

Answer 3

Gordon you re welcome thanks for the reporting.

Answer 4

Same here. Same input as Abdalla. Getting a “No Input” error message - results returned in lowercase. Also getting the same error message for the end module exercise!

Answer 5

You can use the InitCap() function. It worked for me.

It’s a workaround until the bugs are squashed😀

https://oraclesql.in/initcap/

Answer 6

Abdalla Moha yes it works:

SELECT InitCap(ProductName) as ProductName , ProductionDate, ExpirationDate
FROM Products

Answer 7

No sir - it does! I used it to solve both the ‘Multiple Columns’ and ‘Cakes’ excersises in the Sololearn editor!

Answer 8

The problem is still there on my side

Answer 9

Md Sayed thanks man i hope it will be fixed soon.

Answer 10

Same problem here 👍

Answer 11

Shawn Blackman thanks man initcap function is not working inside sololearn editor I think it's for oracle not mysql sololearn uses mysql database.

Answer 12

Jozef Šulej👍🏾🍷

Answer 13

Jozef Šulej it worked for me at last thank you so much

Answer 14

Shawn Blackman i solved the 'Multiple Columns' now I'm heading to the 'Cakes' thanks for the help it means alot to me.

Answer 15

Abdalla Moha 👍🏾👍🏾👍🏾

Answer 16

Have you tried to do that?
SELECT ProductName, ProductionDate, ExparitonDate FROM Products;

Answer 17

Control a