We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 9
Weather Observation Station 9
Sort by
recency
|
3286 Discussions
|
Please Login in order to post a comment
Approach - 1 (REGEXP)
SELECT DISTINCT CITY FROM STATION WHERE CITY NOT REGEXP '^[aeiou]'
Approach - 2 (SUBSTRING)
SELECT DISTINCT CITY FROM STATION WHERE SUBSTRING(CITY, 1, 1) NOT IN ('a', 'e', 'i', 'o', 'u')
Approach - 3 (LEFT FUNCTION)
SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY, 1) NOT IN ('a', 'e', 'i', 'o', 'u')
Approach - 4 (LIKE OPERATOR)
SELECT DISTINCT CITY FROM STATION WHERE CITY NOT LIKE 'a%' AND CITY NOT LIKE 'e%' AND CITY NOT LIKE 'i%' AND CITY NOT LIKE 'o%' AND CITY NOT LIKE 'u%'
P.S. All above operators (IN, LIKE, REGEXP) used are case insensitive, so no need to write 'a' and 'A', simply 'a' will do the work for both the cases
Upvote if it helped :)
The best weather for a wedding typically depends on the couple's preferences and the type of event they envision. Generally, mild temperatures with clear skies, such as those found in spring or early autumn, are ideal. These seasons offer pleasant weather, blooming flowers, and less chance of extreme heat or cold, making them perfect for outdoor ceremonies and receptions. Wedding
The issues previously mentioned persist in the process of integrating SQL with the Fia Weavers data. Despite the involvement of multiple experts, a definitive solution has yet to be identified. This is particularly evident in aspects such as pricing considerations related to Fia Weavers.
SELECT DISTINCT CITY FROM STATION WHERE CITY NOT LIKE 'A%' AND CITY NOT LIKE 'E%' AND CITY NOT LIKE 'I%' AND CITY NOT LIKE 'O%' AND CITY NOT LIKE 'U%' AND CITY NOT LIKE 'a%' AND CITY NOT LIKE 'e%' AND CITY NOT LIKE 'i%' AND CITY NOT LIKE 'o%' AND CITY NOT LIKE 'u%' ORDER BY CITY;
SELECT distinct CITY FROM STATION WHERE LEFT(CITY, 1) NOT IN ('a' , 'e' , 'i' , 'o' , 'u');