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.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 7
  5. Discussions

Weather Observation Station 7

  • chwin_robkob
     + 0 comments

    Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

    1. result cannot duplicates == use "DISTINCT"
    2. list of CITY names . . . from STATION == "SELECT DISTINCT CITY FROM STATION"
    3. list of CITY names ending with vowels (a, e, i, o, u) == use LIKE, find ending use "%symbols", example '%a'

    SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u';