Thursday, March 4, 2021

Select All | Hackerrank | Basic Select | SQL | Basic Select | Solution

 


Problem : https://www.hackerrank.com/challenges/select-all-sql/problem

Solution : 


SELECT * FROM CITY;











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

 



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

Solution : 

SELECT NAME FROM CITY WHERE COUNTRYCODE = "JPN";









Select By ID | Basic Select | Hackerrank | Solution | SQL

 



Problem : https://www.hackerrank.com/challenges/select-by-id/problem

Solution : 

SELECT * FROM CITY WHERE ID = 1661;












Revising the Select Query II | Hackerrank | SQL | Basic Select | Solution

 



Problem : https://www.hackerrank.com/challenges/revising-the-select-query-2/problem

Solution : 

SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE = "USA";






Revising the Select Query I | HackerRank | Basic Select | SQL | Complete Playlist




 PROBLEM : https://www.hackerrank.com/challenges/revising-the-select-query/problem

SOLUTION : 

SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = "USA";










Friday, January 1, 2021

Covariant Return Types | Advanced Java | HackerRank | Solution | Color The Code



Problem : https://www.hackerrank.com/challenges/java-covariance/problem

Solution :

Java Singleton Pattern | Advanced Java | OOP Patterns | HackerRank | Solution | Color The Code



Problem : https://www.hackerrank.com/challenges/java-singleton/problem

Solution : 

Java Factory Pattern | Advanced Java | OOP Patterns | HackerRank | Solution | Color The Code



Problem : https://www.hackerrank.com/challenges/java-factory/problem

Solution : 

Java Reflection - Attributes | Advanced Java | HackerRank | Practice | Solution | Color The Code



Problem : https://www.hackerrank.com/challenges/java-reflection-attributes/problem

Solution :

Java Varargs - Simple Addition | Advanced Java | HackerRank | Practice | Solution | Color The Code



Problem : https://www.hackerrank.com/challenges/simple-addition-varargs/problem

Solution : 

Java Exception Handling | Exception Handling | HackerRank | Java | Solution | Color The Code



Problem : https://www.hackerrank.com/challenges/java-exception-handling/problem

Solution :

Java Exception Handling (Try-catch) | Exception Handling | HackerRank | Java | Practice | Solution | Color The Code



Problem : https://www.hackerrank.com/challenges/java-exception-handling-try-catch/problem

Solution :

Java Iterator | OOP | HackerRank | Java | Practice | Solution | Color The Code



Problem : https://www.hackerrank.com/challenges/java-iterator/problem

Solution :