Weather Observation Station hackerrank

part11.sql

SELECT DISTINCT city
FROM station
WHERE city REGEXP '^[^aeiouAEIOU]'
  or city REGEXP '[^aeiouAEIOU]$';

part5.sql

-- select bagian atas: nyarii yang paling pendek
(select city, length(city)
from station
where length(city) = (
  select min(length(city)) from station
) 
order by city asc 
limit 1)

union all -- buat nyatuin statement select yg atas dan bawah ini

-- select bagian atas: nyarii yang paling panjang
(select city, length(city)
from station
where length(city) = (
  select max(length(city)) from station
) -- >> nyari nama city yang paling panjang
order by city asc -- kalo nemu banyak, urutin secara alfabet [abcdef-wxyz]
limit 1 -- dari banyak data, pilih 1 aja
)

/*
Output:
    Amo 3
    Marine On Saint Croix 21
*/

part6.sql

select distinct city 
from station
/*where city like 'a%' 
  or city like 'i%' 
  or city like 'u%' 
  or city like 'e%'
  or city like 'o%';*/
where city REGEXP '^[aeiouAEIOU]' -- til, ternyata bisa pake regex