Archives hackerrank - Stránka 16 z 25

Hackerrank – Java Stdin and Stdout 1

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

import java.util.*;

public class Solution
{
    public static void main(String[] args)
    {
        Scanner sc=new Scanner(System.in);
        int a=sc.nextInt();
        int b = sc.nextInt();
        int c = sc.nextInt();

        System.out.println(a);
        System.out.println(b);
        System.out.println(c);
    }
}

import java.util.*;

public class Solution

{

public static void main(String[] args)

{

Scanner sc=new Scanner(System.in);

int a=sc.nextInt();

int b = sc.nextInt();

int c = sc.nextInt();

System.out.println(a);

System.out.println(b);

System.out.println(c);

}

Hackerrank – Is Fibo

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie Vytvoríme si Fibonacciho postupnosť a zistíme, či sa fibonaciho číslo rovná požadovanému n. Vytvoril som riešenie v týchto programovacích jazykoch: Java JavaScript Scala Ruby Všetky riešenia sú dostupné aj na mojom GitHub profile. Java

import java.math.BigInteger;
import java.util.*;

public class IsFibo {

    public static void main(String[] args) {
        Scanner stdin = new Scanner(System.in);
        int tests = stdin.nextInt();
        for(int i = 0; i < tests; i++) {
            BigInteger n = stdin.nextBigInteger();
            System.out.println(isFibo(n));
        }
        stdin.close();
    }

    private static String isFibo(BigInteger n) {
        BigInteger fib0 = BigInteger.ZERO;
        BigInteger fib1 = BigInteger.ONE;
        while(fib0.compareTo(n) <= 0) {
            if (fib0.compareTo(n) == 0) return "IsFibo";
            BigInteger temp = fib0;
            fib0 = fib1;
            fib1 = fib1.add(temp);
        }
        return "IsNotFibo";
    }
}

import java.math.BigInteger;

import java.util.*;

public class IsFibo {

public static void main(String[] args) {

Scanner stdin = new Scanner(System.in);

int tests = stdin.nextInt();

for(int i = 0; i < tests; i++) {

BigInteger n = stdin.nextBigInteger();

System.out.println(isFibo(n));

}

stdin.close();

}

private static String isFibo(BigInteger n) {

BigInteger fib0 = BigInteger.ZERO;

BigInteger fib1 = BigInteger.ONE;

while(fib0.compareTo(n) <= 0) {

if (fib0.compareTo(n) == 0) return "IsFibo";

BigInteger temp = fib0;

fib0 = fib1;

fib1 = fib1.add(temp);

}

return "IsNotFibo";

}

JavaScript

'use strict';

let isFibo = n => {
    let fib0 = 0;
    let fib1 = 1;
    while(fib0 <= n) {
        if (fib0 == n) return "IsFibo";
        let temp = fib0;
        fib0 = fib1;
        fib1 += temp;
    }
    return "IsNotFibo"
};
const processData = input => {
    console.log(input.split("\n").slice(1).map(i => parseInt(i)).map(isFibo).join("\n"));
};

process.stdin.resume();
process.stdin.setEncoding("ascii");

var _input = "";
process.stdin.on("data", input => _input += input);
process.stdin.on("end", () => processData(_input));

'use strict';

let isFibo = n => {

let fib0 = 0;

let fib1 = 1;

while(fib0 <= n) {

if (fib0 == n) return "IsFibo";

let temp = fib0;

fib0 = fib1;

fib1 += temp;

}

return "IsNotFibo"

};

const processData = input => {

console.log(input.split("\n").slice(1).map(i => parseInt(i)).map(isFibo).join("\n"));

};

process.stdin.resume();

process.stdin.setEncoding("ascii");

var _input = "";

process.stdin.on("data", input => _input += input);

process.stdin.on("end", () => processData(_input));

Scala

import scala.io.Source

object IsFibo extends App {
  val lines = Source.stdin.getLines()
  val numbers = lines.drop(1).map(BigInt(_))
  val fibos = numbers.map(isFibo)
  println(fibos.mkString("\n"))

  def isFibo(n: BigInt): String = {
    var fib0: BigInt = 0
    var fib1: BigInt = 1
    while(fib0 <= n) {
      if (fib0 == n) return "IsFibo"
      val temp: BigInt = fib0
      fib0 = fib1
      fib1 += temp
    }
    "IsNotFibo"
  }
}

import scala.io.Source

object IsFibo extends App {

val lines = Source.stdin.getLines()

val numbers = lines.drop(1).map(BigInt(_))

val fibos = numbers.map(isFibo)

println(fibos.mkString("\n"))

def isFibo(n: BigInt): String = {

var fib0: BigInt = 0

var fib1: BigInt = 1

while(fib0 <= n) {

if (fib0 == n) return "IsFibo"

val temp: BigInt = fib0

fib0 = fib1

fib1 += temp

}

"IsNotFibo"

}

Ruby

def is_fibo(number)
  fib0 = 0
  fib1 = 1
  while fib0 <= number do
    return "IsFibo" if fib0 == number
    temp = fib0
    fib0 = fib1
    fib1 += temp
  end
  return "IsNotFibo"  
end

test_cases = gets.chomp.to_i
test_cases.times do
  number = gets.chomp.to_i
  result = is_fibo(number)
  puts result
end

def is_fibo(number)

fib0 = 0

fib1 = 1

while fib0 <= number do

return "IsFibo" if fib0 == number

temp = fib0

fib0 = fib1

fib1 += temp

end

return "IsNotFibo"

end

test_cases = gets.chomp.to_i

test_cases.times do

number = gets.chomp.to_i

result = is_fibo(number)

puts result

end

Hackerrank – IP Address Validation

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie IP4 regex: \b(((2[0-5][0-5])|(1[0-9][0-9])|(\b[1-9][0-9]\b)|(\b\d\b))\.){3}((2[0-5][0-5])|(1[0-9][0-9])|(\b[1-9][0-9]\b)|(\b\d\b))\b IP6 regex: ([a-f0-9]{1,4}:){7}\b[0-9a-f]{1,4}\b Vytvoril som riešenie v týchto programovacích jazykoch: Java JavaScript Scala Ruby Všetky riešenia sú dostupné aj na mojom GitHub profile. Java

import java.util.*;

public class IPAddressValidation {

    private static final String IP6_PATTERN = "([a-f0-9]{1,4}:){7}\\b[0-9a-f]{1,4}\\b";
    private static final String IP4_PATTERN =
            "\\b(((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\.){3}((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\b";

    public static void main(String[] args) {
        Scanner stdin = new Scanner(System.in);
        int tests = Integer.parseInt(stdin.nextLine());
        for(int i = 0; i < tests; i++) {
            System.out.println(ipValidation(stdin.nextLine()));
        }
        stdin.close();
    }

    private static String ipValidation(String address) {
        if(address.matches(IP6_PATTERN))
            return "IPv6";
        else if(address.matches(IP4_PATTERN))
            return "IPv4";
        else
            return "Neither";
    }
}

import java.util.*;

public class IPAddressValidation {

private static final String IP6_PATTERN = "([a-f0-9]{1,4}:){7}\\b[0-9a-f]{1,4}\\b";

private static final String IP4_PATTERN =

"\\b(((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\.){3}((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\b";

public static void main(String[] args) {

Scanner stdin = new Scanner(System.in);

int tests = Integer.parseInt(stdin.nextLine());

for(int i = 0; i < tests; i++) {

System.out.println(ipValidation(stdin.nextLine()));

}

stdin.close();

}

private static String ipValidation(String address) {

if(address.matches(IP6_PATTERN))

return "IPv6";

else if(address.matches(IP4_PATTERN))

return "IPv4";

else

return "Neither";

}

JavaScript

'use strict';

const IP6_PATTERN = "([a-f0-9]{1,4}:){7}\\b[0-9a-f]{1,4}\\b";
const IP4_PATTERN =
    "\\b(((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\.){3}((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\b";

const processData = input => {
    let lines = input.split('\n').slice(1);
    let ipValidation = address => {
        if(address.match(new RegExp(IP4_PATTERN))) {
            return "IPv4";
        } else if(address.match(new RegExp(IP6_PATTERN))) {
            return "IPv6";
        } else {
            return "Neither";
        }
    };
    let validations = lines.map(ipValidation);
    console.log(validations.join('\n'));
};

process.stdin.resume();
process.stdin.setEncoding("ascii");

var _input = "";
process.stdin.on("data", input => _input += input);
process.stdin.on("end", () => processData(_input));

'use strict';

const IP6_PATTERN = "([a-f0-9]{1,4}:){7}\\b[0-9a-f]{1,4}\\b";

const IP4_PATTERN =

"\\b(((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\.){3}((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\b";

const processData = input => {

let lines = input.split('\n').slice(1);

let ipValidation = address => {

if(address.match(new RegExp(IP4_PATTERN))) {

return "IPv4";

} else if(address.match(new RegExp(IP6_PATTERN))) {

return "IPv6";

} else {

return "Neither";

}

};

let validations = lines.map(ipValidation);

console.log(validations.join('\n'));

};

process.stdin.resume();

process.stdin.setEncoding("ascii");

var _input = "";

process.stdin.on("data", input => _input += input);

process.stdin.on("end", () => processData(_input));

Scala

import scala.io.Source

object IPAddressValidation extends App {
  private[this] val IP6_PATTERN = "([a-f0-9]{1,4}:){7}\\b[0-9a-f]{1,4}\\b"
  private[this] val IP4_PATTERN =
    "\\b(((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\.){3}((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\b"

  val lines = Source.stdin.getLines().drop(1)
  val validation = lines.map(ipValidation)
  println(validation.mkString("\n"))

  def ipValidation(address: String): String = {
    if(address.matches(IP6_PATTERN))
      "IPv6"
    else if(address.matches(IP4_PATTERN))
      "IPv4"
    else
      "Neither"
  }
}

import scala.io.Source

object IPAddressValidation extends App {

private[this] val IP6_PATTERN = "([a-f0-9]{1,4}:){7}\\b[0-9a-f]{1,4}\\b"

private[this] val IP4_PATTERN =

"\\b(((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\.){3}((2[0-5][0-5])|(1[0-9][0-9])|(\\b[1-9][0-9]\\b)|(\\b\\d\\b))\\b"

val lines = Source.stdin.getLines().drop(1)

val validation = lines.map(ipValidation)

println(validation.mkString("\n"))

def ipValidation(address: String): String = {

if(address.matches(IP6_PATTERN))

"IPv6"

else if(address.matches(IP4_PATTERN))

"IPv4"

else

"Neither"

}

Ruby

tests = gets.chomp.to_i
tests.times do
  input = gets.chomp.to_s
  if input =~ /\b(((2[0-5][0-5])|(1[0-9][0-9])|(\b[1-9][0-9]\b)|(\b\d\b))\.){3}((2[0-5][0-5])|(1[0-9][0-9])|(\b[1-9][0-9]\b)|(\b\d\b))\b/
    puts "IPv4" 
  elsif input =~ /([a-f0-9]{1,4}:){7}\b[0-9a-f]{1,4}\b/
    puts "IPv6"
  else
    puts "Neither"
  end
end

tests = gets.chomp.to_i

tests.times do

input = gets.chomp.to_s

if input =~ /\b(((2[0-5][0-5])|(1[0-9][0-9])|(\b[1-9][0-9]\b)|(\b\d\b))\.){3}((2[0-5][0-5])|(1[0-9][0-9])|(\b[1-9][0-9]\b)|(\b\d\b))\b/

puts "IPv4"

elsif input =~ /([a-f0-9]{1,4}:){7}\b[0-9a-f]{1,4}\b/

puts "IPv6"

else

puts "Neither"

end

Hackerrank – Intro to Tutorial Challenges

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie Zisti, či existujú prvky poľa, ktoré sa rovnajú zadanej hodnote. Vytvoril som riešenie v týchto programovacích jazykoch: Java JavaScript Scala Ruby Všetky riešenia sú dostupné aj na mojom GitHub profile. Java

import java.util.Scanner;

public class IntroToTutorialChallenges
{
    public static void main(String[] args)
    {
        Scanner stdin = new Scanner(System.in);
        int v = Integer.parseInt(stdin.nextLine());
        int size = Integer.parseInt(stdin.nextLine());
        String[] numbers = stdin.nextLine().split(" ");
        System.out.println(getPosition(numbers, v));
        
        stdin.close();
    }
    
    private static int getPosition(String[] numbers, int v)
    {
        for(int i = 0; i < numbers.length; i++)
        {
            if(v == Integer.parseInt(numbers[i]))
            {
                return i;
            }
        }
        return 0;
    }
}

import java.util.Scanner;

public class IntroToTutorialChallenges

{

public static void main(String[] args)

{

Scanner stdin = new Scanner(System.in);

int v = Integer.parseInt(stdin.nextLine());

int size = Integer.parseInt(stdin.nextLine());

String[] numbers = stdin.nextLine().split(" ");

System.out.println(getPosition(numbers, v));

stdin.close();

}

private static int getPosition(String[] numbers, int v)

{

for(int i = 0; i < numbers.length; i++)

{

if(v == Integer.parseInt(numbers[i]))

{

return i;

}

return 0;

}

JavaScript

'use strict';

const processData = input => {
    let getPosition = (arr, val) => {
        for(let i = 0; i < arr.length; i++) {
            if(arr[i] == val) {
                return i;
            }
        }
    };
    let lines = input.split('\n');
    let searchedValue = parseInt(lines[0]);
    let array = lines[2].split(' ').map(i => parseInt(i));
    let position = getPosition(array, searchedValue);
    console.log(position);
};

process.stdin.resume();
process.stdin.setEncoding("ascii");

var _input = "";
process.stdin.on("data", input => _input += input);
process.stdin.on("end", () => processData(_input));

'use strict';

const processData = input => {

let getPosition = (arr, val) => {

for(let i = 0; i < arr.length; i++) {

if(arr[i] == val) {

return i;

}

};

let lines = input.split('\n');

let searchedValue = parseInt(lines[0]);

let array = lines[2].split(' ').map(i => parseInt(i));

let position = getPosition(array, searchedValue);

console.log(position);

};

process.stdin.resume();

process.stdin.setEncoding("ascii");

var _input = "";

process.stdin.on("data", input => _input += input);

process.stdin.on("end", () => processData(_input));

Scala

import scala.io.Source

object IntroToTutorialChallenges extends App {
  val lines = Source.stdin.getLines().toList
  val searchedValue = lines(0).toInt
  val array = lines(2).split(" ").map(_.toInt)

  val valPosition = getPosition(array, searchedValue)
  println(valPosition)

  def getPosition(array: Array[Int], value: Int): Int = {
    array.indexOf(value)
  }
}

import scala.io.Source

object IntroToTutorialChallenges extends App {

val lines = Source.stdin.getLines().toList

val searchedValue = lines(0).toInt

val array = lines(2).split(" ").map(_.toInt)

val valPosition = getPosition(array, searchedValue)

println(valPosition)

def getPosition(array: Array[Int], value: Int): Int = {

array.indexOf(value)

}

Ruby

def get_position(arr, val)
  (arr.size - 1).times do |i|
    return i if(val == arr[i])
  end
end

searched_value = gets.to_s.chomp.to_i
array_length = gets.to_s.chomp.to_i
arr = gets.to_s.split.map{ |i| i.to_i }

position = get_position(arr, searched_value)
puts position

def get_position(arr, val)

(arr.size - 1).times do |i|

return i if(val == arr[i])

end

searched_value = gets.to_s.chomp.to_i

array_length = gets.to_s.chomp.to_i

arr = gets.to_s.split.map{ |i| i.to_i }

position = get_position(arr, searched_value)

puts position

Hackerrank – Insertion Sort – Part 1

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie Priraď posledný element do nejakej dočasnej premennej. Iteruj od posledného prvku k prvému (index 0). Ak je aktuálny elemen väčší ako dočasná premenná, priraď do dočasnej premennej index aktuálneho prvku. Inak vymeň aktuálny element s predchádzajúcim. Vytvoril som riešenie v týchto programovacích jazykoch: Java JavaScript […]

Hackerrank – Ice Cream Parlor

Popis problému Celý popis zadania sa nacháza – Hackerrank. Riešenie Pre každú i-tú cenovku zisti, či súčet i-tej a (i+1)-ej ceny je rovný požadovanej sume. Vytvoril som riešenie v týchto programovacích jazykoch: Java JavaScript Scala Ruby Všetky riešenia sú dostupné aj na mojom GitHub profile. Java

import java.util.*;

public class IceCreamParlor {

    public static void main(String[] args) {
        Scanner stdin = new Scanner(System.in);
        int tests = Integer.parseInt(stdin.nextLine());
        for(int i = 0; i < tests; i++) {
            int amount = Integer.parseInt(stdin.nextLine());
            int length = Integer.parseInt(stdin.nextLine());
            int[] costs = new int[length];
            String[] strings = stdin.nextLine().split(" ");
            for(int j = 0; j < length; j++) {
                costs[j] = Integer.parseInt(strings[j]);
            }
            for(int j = 0; j < length - 1; j++) {
                for(int k = j + 1; k < length; k++) {
                    if(costs[j] + costs[k] == amount) {
                        System.out.println((j + 1) + " " + (k + 1));
                    }
                }
            }
        }
        stdin.close();
    }
}

import java.util.*;

public class IceCreamParlor {

public static void main(String[] args) {

Scanner stdin = new Scanner(System.in);

int tests = Integer.parseInt(stdin.nextLine());

for(int i = 0; i < tests; i++) {

int amount = Integer.parseInt(stdin.nextLine());

int length = Integer.parseInt(stdin.nextLine());

int[] costs = new int[length];

String[] strings = stdin.nextLine().split(" ");

for(int j = 0; j < length; j++) {

costs[j] = Integer.parseInt(strings[j]);

}

for(int j = 0; j < length - 1; j++) {

for(int k = j + 1; k < length; k++) {

if(costs[j] + costs[k] == amount) {

System.out.println((j + 1) + " " + (k + 1));

}

stdin.close();

}

JavaScript

'use strict';

const processData = input => {
    let lines = input.split('\n');
    let tests = parseInt(lines[0]);
    let index = 1;
    for(let i = 0; i < tests; i++) {
        let amount = parseInt(lines[index++]);
        let lenght = parseInt(lines[index++]);
        let costs = lines[index++].split(" ").map(i => parseInt(i));
        let indexes = [];
        for(let j = 0; j < lenght - 1; j++) {
            for(let k = j + 1; k < lenght; k++) {
                if(costs[j] + costs[k] === amount) {
                    indexes.push(j + 1);
                    indexes.push(k + 1);
                }
            }
        }
        console.log(indexes.join(" "));
    }
};

process.stdin.resume();
process.stdin.setEncoding("ascii");

var _input = "";
process.stdin.on("data", input => _input += input);
process.stdin.on("end", () => processData(_input));

'use strict';

const processData = input => {

let lines = input.split('\n');

let tests = parseInt(lines[0]);

let index = 1;

for(let i = 0; i < tests; i++) {

let amount = parseInt(lines[index++]);

let lenght = parseInt(lines[index++]);

let costs = lines[index++].split(" ").map(i => parseInt(i));

let indexes = [];

for(let j = 0; j < lenght - 1; j++) {

for(let k = j + 1; k < lenght; k++) {

if(costs[j] + costs[k] === amount) {

indexes.push(j + 1);

indexes.push(k + 1);

}

console.log(indexes.join(" "));

}

};

process.stdin.resume();

process.stdin.setEncoding("ascii");

var _input = "";

process.stdin.on("data", input => _input += input);

process.stdin.on("end", () => processData(_input));

Scala

import scala.collection.mutable.ListBuffer
import scala.io.Source

object IceCreamParlor extends App {
  val console = Source.stdin.bufferedReader()
  val tests = console.readLine().toInt
  (0 until tests).foreach(_ => {
    val amount = console.readLine().toInt
    val lenght = console.readLine().toInt
    val costs = console.readLine().split(" ").map(_.toInt)
    println(indexes(costs, amount).mkString(" "))
  })

  def indexes(costs: Array[Int], amount: Int): List[Int] = {
    val result: ListBuffer[Int] = ListBuffer.empty
    (0 until costs.length - 1).foreach(i => {
      (i + 1 until costs.length).foreach(j => {
        if(costs(i) + costs(j) == amount) {
          result += i + 1
          result += j + 1
        }
      })
    })
    result.toList
  }
}

import scala.collection.mutable.ListBuffer

import scala.io.Source

object IceCreamParlor extends App {

val console = Source.stdin.bufferedReader()

val tests = console.readLine().toInt

(0 until tests).foreach(_ => {

val amount = console.readLine().toInt

val lenght = console.readLine().toInt

val costs = console.readLine().split(" ").map(_.toInt)

println(indexes(costs, amount).mkString(" "))

})

def indexes(costs: Array[Int], amount: Int): List[Int] = {

val result: ListBuffer[Int] = ListBuffer.empty

(0 until costs.length - 1).foreach(i => {

(i + 1 until costs.length).foreach(j => {

if(costs(i) + costs(j) == amount) {

result += i + 1

result += j + 1

}

})

result.toList

}

Ruby

tests = gets.chomp.to_i
tests.times do
  m = gets.chomp.to_i
  n = gets.chomp.to_i
  flavors = gets.chomp.split.map { |e| e.to_i }
  for i in 0...flavors.length - 1 do
    for j in i + 1...flavors.length do
      puts "#{i + 1} #{j + 1}" if flavors[i] + flavors[j] == m
    end
  end
end

tests = gets.chomp.to_i

tests.times do

m = gets.chomp.to_i

n = gets.chomp.to_i

flavors = gets.chomp.split.map { |e| e.to_i }

for i in 0...flavors.length - 1 do

for j in i + 1...flavors.length do

puts "#{i + 1} #{j + 1}" if flavors[i] + flavors[j] == m

end

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;

Pavol Pidanič

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

Značka: hackerrank

Hackerrank – Java Stdin and Stdout 1

Hackerrank – Is Fibo

Hackerrank – IP Address Validation

Hackerrank – Intro to Tutorial Challenges

Hackerrank – Insertion Sort – Part 1

Hackerrank – Ice Cream Parlor

Hackerrank – Weather Observation Station 5

Hackerrank – Weather Observation Station 6

Hackerrank – Weather Observation Station 7

Hackerrank – Weather Observation Station 8