Friday, June 11, 2021

Arrays - DS | HackerRank | DS | Arrays | Color the Code

 Arrays - DS ( HackerRank )


Solution : 


import java.io.*;
import java.math.*;
import java.security.*;
import java.text.*;
import java.util.*;
import java.util.concurrent.*;
import java.util.function.*;
import java.util.regex.*;
import java.util.stream.*;
import static java.util.stream.Collectors.joining;
import static java.util.stream.Collectors.toList;

class Result {

    /*
     * Complete the 'reverseArray' function below.
     *
     * The function is expected to return an INTEGER_ARRAY.
     * The function accepts INTEGER_ARRAY a as parameter.
     */

    public static List<Integer> reverseArray(List<Integer> a) {
    // Write your code here
        
    Collections.reverse(a);
    return a;
    }

}

public class Solution {
    public static void main(String[] args) throws IOException {
        BufferedReader bufferedReader = new BufferedReader(new 
        InputStreamReader(System.in));
        BufferedWriter bufferedWriter = new BufferedWriter(new 
        FileWriter(System.getenv("OUTPUT_PATH")));

        int arrCount = Integer.parseInt(bufferedReader.readLine()
        .trim());

        List<Integer> arr = Stream.of(bufferedReader.readLine()
        .replaceAll("\\s+$""").split(" "))
        .map(Integer::parseInt)
        .collect(toList());

        List<Integer> res = Result.reverseArray(arr);

        bufferedWriter.write(
            res.stream()
                .map(Object::toString)
                .collect(joining(" "))
            + "\n"
        );

        bufferedReader.close();
        bufferedWriter.close();
    }
}




                        

Friday, March 5, 2021

Weather Observation Station 12 | Basic Select | SQL | HackerRank | Solution



Problem : https://www.hackerrank.com/challenges/weather-observation-station-12/problem

Solution :

/*

Enter your query here.

*/


SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY,1) NOT IN ('a','e','i','o','u') AND RIGHT(CITY,1) NOT IN ('a','e','i','o','u');












Weather Observation Station 11 | Basic Select | SQL | HackerRank | Solution



Problem : https://www.hackerrank.com/challenges/weather-observation-station-11/problem

Solution : 


/*

Enter your query here.

*/


SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY,1) NOT IN ('a','e','i','o','u') OR RIGHT(CITY,1) NOT IN ('a','e','i','o','u');












Weather Observation Station 10 | Basic Select | SQL | HackerRank | Solution



Problem : https://www.hackerrank.com/challenges/weather-observation-station-10/problem

Solution :


/*

Enter your query here.

*/


SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY,1) NOT IN ('a','e','o','u','i');











Weather Observation Station 9 | Basic Select | SQL | HackerRank | Solution



Problem : https://www.hackerrank.com/challenges/weather-observation-station-9/problem

Solution :


/*

Enter your query here.

*/


SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY,1) NOT IN ('a','e','i','o','u');











Weather Observation Station 8 | Basic Select | SQL | HackerRank | Solution



Problem : https://www.hackerrank.com/challenges/weather-observation-station-8/problem

Solution : 

/*

Enter your query here.

*/


SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY,1) IN ('a','e','i','o','u') AND RIGHT(CITY,1) IN ('a','e','i','o','u'); 

Weather Observation Station 7 | Basic Select | SQL | Practice | HackerRank | Solution

 


Problem : https://www.hackerrank.com/challenges/weather-observation-station-7/problem

Solution : 

/*

Enter your query here.

*/


SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY,1) IN ('a','e','i','u','o');


Weather Observation Station 6 | Basic Select | SQL | HackerRank Solution

 


Problem : https://www.hackerrank.com/challenges/weather-observation-station-6/problem

Solution :


/*

Enter your query here.

*/


SELECT CITY FROM STATION WHERE LEFT(CITY,1) IN ('a','e','i','o','u');











Weather Observation Station 5 | SQL | Basic Select | HackerRank | Solution

 


Problem : https://www.hackerrank.com/challenges/weather-observation-station-5/problem

Solution :


/*

Enter your query here.

*/


(

SELECT CITY , LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY LIMIT 1

UNION

(

SELECT CITY , LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY LIMIT 1

);














Weather Observation Station 4 | Basic Select | SQL | Easy | HackerRank | Solution

 


Problem : https://www.hackerrank.com/challenges/weather-observation-station-4/problem

Solution : 


/*

Enter your query here.

*/


SELECT COUNT(CITY) - COUNT(DISTINCT(CITY)) FROM STATION;











Weather Observation Station 3 | Basic Select | SQL | HackerRank Solution

 


Problem : https://www.hackerrank.com/challenges/weather-observation-station-3/problem

Solution : 


/*

Enter your query here.

*/


SELECT DISTINCT(CITY) FROM STATION WHERE ID%2=0; 










Weather Observation Station 1 | Basic Select | SQL | HackerRank | Solution


Problem : https://www.hackerrank.com/challenges/weather-observation-station-1/problem

Solution : 

/*

Enter your query here.

*/


SELECT CITY , STATE FROM STATION;

























Japanese Cities' Attributes | Basic Select | SQL | Hackerrank | Solution


Problem : https://www.hackerrank.com/challenges/japanese-cities-attributes/problem

Solution : 


SELECT * FROM CITY WHERE COUNTRYCODE="JPN";