Archives oracle - Pavol Pidanič

Hackerrank – Weather Observation Station 5

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie Vytvoril som riešenie v týchto programovacích jazykoch: SQL Všetky riešenia sú dostupné aj na mojom GitHub profile. SQL

select * from
( 
    select city, length(city)
    from station
    order by length(city) asc, city asc
)
where rownum = 1
union 
select * from
( 
    select city, length(city)
    from station
    order by length(city) desc, city asc
)
where rownum = 1;

select * from

(

select city, length(city)

from station

order by length(city) asc, city asc

)

where rownum = 1

union

select * from

(

select city, length(city)

from station

order by length(city) desc, city asc

)

where rownum = 1;

Hackerrank – Weather Observation Station 6

select distinct city
from station
where lower(substr(city, 1, 1)) in ('a', 'e', 'i', 'o', 'u')
    order by city asc;

select distinct city

from station

where lower(substr(city, 1, 1)) in ('a', 'e', 'i', 'o', 'u')

order by city asc;

Hackerrank – Weather Observation Station 7

select distinct city
  from station
where 
  substr(lower(city), length(city), 1) in ('a', 'e', 'i', 'o', 'u')
  order by city;

select distinct city

from station

where

substr(lower(city), length(city), 1) in ('a', 'e', 'i', 'o', 'u')

order by city;

Hackerrank – Weather Observation Station 8

select distinct city
  from station
where 
  substr(lower(city), 1, 1) in ('a', 'e', 'i', 'o', 'u')
     AND
  substr(lower(city), length(city), 1) in ('a', 'e', 'i', 'o', 'u')
  order by city;

select distinct city

from station

where

substr(lower(city), 1, 1) in ('a', 'e', 'i', 'o', 'u')

AND

substr(lower(city), length(city), 1) in ('a', 'e', 'i', 'o', 'u')

order by city;

Hackerrank – Weather Observation Station 9

select distinct city
from station
where lower(substr(city, 1, 1)) not in ('a', 'e', 'i', 'o', 'u')
    order by city asc;

select distinct city

from station

where lower(substr(city, 1, 1)) not in ('a', 'e', 'i', 'o', 'u')

order by city asc;

Hackerrank – Weather Observation Station 10

select distinct city
  from station
where 
  substr(lower(city), length(city), 1) not in ('a', 'e', 'i', 'o', 'u')
  order by city;

select distinct city

from station

where

substr(lower(city), length(city), 1) not in ('a', 'e', 'i', 'o', 'u')

order by city;

Hackerrank – Weather Observation Station 11

select distinct city
  from station
where 
  substr(lower(city), 1, 1) not in ('a', 'e', 'i', 'o', 'u')
     or
  substr(lower(city), length(city), 1) not in ('a', 'e', 'i', 'o', 'u')
  order by city;

select distinct city

from station

where

substr(lower(city), 1, 1) not in ('a', 'e', 'i', 'o', 'u')

substr(lower(city), length(city), 1) not in ('a', 'e', 'i', 'o', 'u')

order by city;

Hackerrank – Weather Observation Station 12

select distinct city
  from station
where 
  substr(lower(city), 1, 1) not in ('a', 'e', 'i', 'o', 'u')
     and
  substr(lower(city), length(city), 1) not in ('a', 'e', 'i', 'o', 'u')
  order by city;

select distinct city

from station

where

substr(lower(city), 1, 1) not in ('a', 'e', 'i', 'o', 'u')

and

substr(lower(city), length(city), 1) not in ('a', 'e', 'i', 'o', 'u')

order by city;

Hackerrank – Higher Than 75 Marks

select name from 
(
    select name, substr(name, length(name)-2) as sub_name 
    from Students
    where marks > 75 order by sub_name, id asc
);

select name from

(

select name, substr(name, length(name)-2) as sub_name

from Students

where marks > 75 order by sub_name, id asc

);

Hackerrank – Japanese Cities‘ Detail

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie Vyber všetky riadky ak CoutryCode stĺpec sa rovná ‚JPN‘. Vytvoril som riešenie v týchto programovacích jazykoch: SQL Všetky riešenia sú dostupné aj na mojom GitHub profile. SQL

select * from City where CountryCode = 'JPN';

1	select * from City where CountryCode = 'JPN';

Pavol Pidanič

Dokážem na 10 prstoch napočítať do 1023

Značka: oracle

Hackerrank – Weather Observation Station 5

Hackerrank – Weather Observation Station 6

Hackerrank – Weather Observation Station 7

Hackerrank – Weather Observation Station 8

Hackerrank – Weather Observation Station 9

Hackerrank – Weather Observation Station 10

Hackerrank – Weather Observation Station 11

Hackerrank – Weather Observation Station 12

Hackerrank – Higher Than 75 Marks

Hackerrank – Japanese Cities‘ Detail