11 Weather Observation Station 7
SQL Learning series | Learn SQL by solving coding challenges.
Hackerrank : https://www.hackerrank.com/domains/sql
GitHub : https://github.com/Ajay-user/Learn-SQL
-- CITY names ENDS with a vowels ('a', 'e', 'i', 'o', 'u')
-- Your result cannot contain duplicates.
-- LOWER(str) : Return the argument in lowercase
-- Returns the string str with all characters changed to lowercase
-- SUBSTRING(str,pos,len) : Return the substring as specified
-- with a len argument return a substring len characters long
-- from string str, starting at position pos
#sql #mysql #hackerrank #learning #coding