Pavol Pidanič

Hackerrank – Weather Observation Station 8

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 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';

Hackerrank – Japanese Cities‘ Name

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie Vyber iba Name stĺpec a nastav filter pre CountryCode stĺpec 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 Name from City where CountryCode = 'JPN';

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

Hackerrank – Revising the Select Query – 2

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie Rozdiel medzi Revising the Select Query – 1 je, že vyberáme iba stĺpce name. Vytvoril som riešenie v týchto programovacích jazykoch: SQL Všetky riešenia sú dostupné aj na mojom GitHub profile. SQL

Select name from City
where CountryCode='USA' and population > 120000;

1 2	Select name from City where CountryCode='USA' and population > 120000;

Hackerrank – Revising the Select Query – 1

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie Vyber všetky stĺpce, kde filtrujeme podľa stĺpcov CountryCode a Population. Vytvoril som riešenie v týchto programovacích jazykoch: SQL Všetky riešenia sú dostupné aj na mojom GitHub profile. SQL

Select name from City
where CountryCode='USA' and population > 120000;

1 2	Select name from City where CountryCode='USA' and population > 120000;