Please perhaps just inform use to check which Version of SQL is being used for this excercise as we Beginners who are also new to the site, won't typically check it and realize we should be using a function that works in that specific SQL Version. I myself am not sure where to even look for the version, but I tried the function I had in mind for different versions till it worked.
Awesome Fundemental Train for Beginners! Im also happy that this Kata reminded me that when I use functions, I should remember to use alias to return the column by its original or more readable name.
The Note indeed does hint that the Values of the 'IsActive' is True / False, however Beginners such as myself have no way of knowing that we should use '1' instead of True when coding our solution. Please do clarify on that part! I believe it is valuable for Beginners to learn that True == 1, however without any hints to this I can see it being discouraging or potentially only further confusing people.
added more info, and link to specification data types
As the desc stated, Very Simple! Still a nice train for beginners and a chance to try out different methods of completing such a small calculation.
This comment is hidden because it contains spoiler information about the solution
Loved this excercise! I was previously confused by doing calculations in a select statement, but this made me feel just a bit more confident about it!
Thank you for the nice excercise!
Absolutely loved this train! Good excercise.
Awesome Train!
Please perhaps just inform use to check which Version of SQL is being used for this excercise as we Beginners who are also new to the site, won't typically check it and realize we should be using a function that works in that specific SQL Version. I myself am not sure where to even look for the version, but I tried the function I had in mind for different versions till it worked.
Another great Fundemental Train! 2 new SQL Functions discovered & in the bag. Thank you!
Good fundemental train for Beginners, tysm! I learned a new SQL Function <33
Awesome Fundemental Train for Beginners! Im also happy that this Kata reminded me that when I use functions, I should remember to use alias to return the column by its original or more readable name.
This comment is hidden because it contains spoiler information about the solution
Loved this Kata! Thank you.
Awesome Kata for Beginners, thank you!
Awesome Kata for Beginners such as myself! Love it, thank you.
The Note indeed does hint that the Values of the 'IsActive' is True / False, however Beginners such as myself have no way of knowing that we should use '1' instead of True when coding our solution. Please do clarify on that part! I believe it is valuable for Beginners to learn that True == 1, however without any hints to this I can see it being discouraging or potentially only further confusing people.
Loading more items...