Skip to main content

Posts

Featured

 Weather Observation Station 10 Query the list of  CITY  names from  STATION  that  do not end  with vowels. Your result cannot contain duplicates. Input Format The  STATION  table is described as follows: where  LAT_N  is the northern latitude and  LONG_W  is the western longitude. Following MySQL Commands; Solution: SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[^AEIOU]$' ORDER BY CITY;

Latest Posts