HackerRank_16. Weather Observation Station 10

문제 : Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.

 

SELECT distinct CITY
FROM STATION
WHERE SUBSTR(CITY, -1, 1) NOT IN ('a', 'e', 'i', 'o', 'u');

Kissee Mills Loma Mar Sandy Hook Tipton Arlington Turner Slidell Negreet Chignik Lagoon Hanna City Albany Monument Manchester Prescott Graettinger Sturgis Highwood Bowdon Tyler Watkins Republic Bowdon Junction Hoskinston Talbert Mccomb Kirk Carlock Seward Roy Pattonsburg Centertown Norvell Beaver Island Odin Jemison West Hills Culdesac Roselawn Forest Lakes San Simeon Little Rock Portland New Century Hampden Pine City Sandborn Seaton Prince Frederick Pomona Park Yazoo City Jolon Childs Shreveport Forest Sizerock Buffalo Creek Algonac Onaway Irvington Winsted Woodbury Hackleburg Soldier Arrowsmith Columbus Kirkland Wilton Busby Reeds Hayfork Mcbrides Lee Center Henderson Udall Palm Desert Benedict Oakfield Tamms Haubstadt Clancy Scotts Valley Norwood Elkton Bridgeport Cherry Griffin Pine Bluff Baldwin Pony Franklin Vulcan Prairie Du Rocher Alanson Carver Paron Winchester Greenview Lucerne Valley Cromwell Quinter Whitewater Round Pond Rockton Auburn North Berwick Richland Fremont Philipsburg Kensett Koleen Winslow Reasnor Frankfort Heights Linthicum Heights Pengilly Newton Center Newbury Kismet Canton Clipper Mills Pierre Part Bison Ridgway South Britain Rydal Deerfield Montreal Knob Lick Cranks Rives Junction Ledyard Norway Eros Rantoul Richmond Hill Fredericktown Glen Carbon Fredericksburg Mc Henry Wellington Hoffman Estates Edgewater Ducor Salem Sturdivant East Haddam Larkspur Patriot Carlos Addison Climax Southport Compton Rumsey Rogers Everton Libertytown Church Creek Dumont Gales Ferry Williams Decatur Holbrook Sherrill Linden Sedgwick Fort Atkinson Peachtree City Rocheport West Somerset Clovis Heyburn Peabody Marion Junction Randall Jordan White Horse Beach Macy Flowood Deep River Napoleon Leavenworth Coldwater Weldon Turners Falls Delray Beach Eustis Mineral Point Midpines Tefft Showell Brighton Grimes Nubieber North Monmouth Harmony Beaufort Union Star Humeston Firebrick Ludington Channing West Baden Springs Melber Sanders Ottertail Schleswig Harbor Springs Richmond Siler Reeves Clifton Crescent City Albion Athens Panther Burn Hanscom Afb Bennington Garland Clutier Lupton Northfield Osage City Norris Clopton Saint Paul Kingsland Fairview Bridgton Brownstown Hartland Andover Mesick Dryden Beverly Marine On Saint Croix Pocahontas Yoder Gatewood Madden Cheswold Jack Hawarden Cannonsburg North Branford New Liberty Woodstock Valley Farmington Pfeifer Gridley Fulton Winter Park Del Mar Greens Fork Garden City Blue River New Ross Brilliant Olmitz Allerton Norphlet Mechanic Falls North Middletown Keyes Equality Neon Calhoun Mullan Coalgood Walnut Saint Petersburg Julian Veedersburg Orange Park Payson Windom Ludlow Lindsay Bristol Ukiah Zachary Esmond Hills Montgomery City Delavan Byron Eureka Springs Baker Hyde Park Groveoak Kenner Many Berryton Newark Cowgill Novinger Goodman Cobalt South Haven West Hyannisport Jackson Lapeer Peaks Island Hazlehurst Chester Clarkston Healdsburg Hotchkiss Ravenden Springs Kell Strasburg Five Points Norris City Coaling Orange City Effingham Corcoran Alton Greenway Strawn Dent Shingletown Fort Lupton Agency South Carrollton Taft Knobel Bullhead City Anthony Emmett Haverhill Siloam Freeport Gorham Bass Harbor Granger