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.
WHERE HAVE I GONE WRONG CAN ANYONE POINT OUT MY MISTAKE
WITH LEFT_CITIES AS (
SELECT DISTINCT CITY
FROM STATION
WHERE UPPER(LEFT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U')
),
RIGHT_CITIES AS (
SELECT DISTINCT CITY
FROM STATION
WHERE UPPER(RIGHT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U')
)
SELECT LEFT_CITIES.CITY AS LEFT_CITY, RIGHT_CITIES.CITY AS RIGHT_CITY
FROM LEFT_CITIES, RIGHT_CITIES;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 8
You are viewing a single comment's thread. Return to all comments →
WHERE HAVE I GONE WRONG CAN ANYONE POINT OUT MY MISTAKE
WITH LEFT_CITIES AS ( SELECT DISTINCT CITY FROM STATION WHERE UPPER(LEFT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U') ), RIGHT_CITIES AS ( SELECT DISTINCT CITY FROM STATION WHERE UPPER(RIGHT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U') )
SELECT LEFT_CITIES.CITY AS LEFT_CITY, RIGHT_CITIES.CITY AS RIGHT_CITY FROM LEFT_CITIES, RIGHT_CITIES;