My implementations for solutions of HackerRank challenges.

• Contests
  • ProjectEuler+
• Practice
  • Problem Solving
    • Algorithms
      • Warmup
      • Implementation
    • Data Structures
      • Arrays
  • SQL
    • Basic Select
    • Advanced Select
    • Aggregation
    • Basic Join
    • Advanced Join
    • Alternative Queries

Solution requests and contributions can be done here.

Contests

ProjectEuler+

#	Difficulty	Challenge	Solutions
1	Easy	Multiples of 3 and 5	C#
2	Easy	Even Fibonacci Numbers	C#
3	Easy	Largest Prime Factor	C#

Practice

Problem Solving

Algorithms

Warmup

Difficulty	Skill	Challenge	Solution
Easy	Basic	Solve Me First	C C#
Easy	Basic	Simple Array Sum	C C#
Easy	Basic	Compare the Triplets	C C#
Easy	Basic	A Very Big Sum	C C#
Easy	Basic	Diagonal Difference	C C#
Easy	Basic	Plus Minus	C C#
Easy	Basic	Staircase	C C#
Easy	Basic	Mini-Max Sum	C C#
Easy	Basic	Birthday Cake Candles	C C#
Easy	Basic	Time Conversion	C C#

Implementation

Difficulty	Skill	Challenge	Solution
Easy	Basic	Grading Students	C C#
Easy	Basic	Apple and Orange	C C#
Easy	Basic	Number Line Jumps	C C#
Easy	Basic	Between Two Sets	C C#
Easy	Basic	Breaking the Records	C
Easy	Basic	Subarray Division	C

Data Structures

Arrays

Difficulty	Skill	Challenge	Solution
Easy	Basic	Arrays - DS	C C#
Easy	Basic	2D Array - DS	C C#

SQL

Basic Select

Difficulty	Skill	Challenge	Solution
Easy	Basic	Revising the Select Query I	MySQL MSSQL Oracle
Easy	Basic	Revising the Select Query II	MySQL MSSQL Oracle
Easy	Basic	Select All	MySQL MSSQL Oracle
Easy	Basic	Select By ID	MySQL MSSQL Oracle
Easy	Basic	Japanese Cities' Attributes	MySQL MSSQL Oracle
Easy	Basic	Japanese Cities' Names	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 1	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 3	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 4	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 5	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 6	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 7	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 8	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 9	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 10	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 11	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 12	MySQL MSSQL Oracle
Easy	Basic	Higher Than 75 Marks	MySQL MSSQL Oracle
Easy	Basic	Employee Names	MySQL MSSQL Oracle
Easy	Basic	Employee Salaries	MySQL MSSQL Oracle

Advanced Select

Difficulty	Skill	Challenge	Solution
Easy	Basic	Type of Triangle	MySQL MSSQL Oracle
Medium	Basic	The PADS	MySQL MSSQL Oracle
Medium	Advanced	Occupations	MySQL MSSQL Oracle
Medium	Intermediate	Binary Tree Nodes	MySQL MSSQL Oracle
Medium	Intermediate	New Companies	MySQL MSSQL Oracle

Aggregation

Difficulty	Skill	Challenge	Solution
Easy	Basic	Revising Aggregations - The Count Function	MySQL MSSQL Oracle
Easy	Basic	Revising Aggregations - The Sum Function	MySQL MSSQL Oracle
Easy	Basic	Revising Aggregations - Averages	MySQL MSSQL Oracle
Easy	Basic	Average Population	MySQL MSSQL Oracle
Easy	Basic	Japan Population	MySQL MSSQL Oracle
Easy	Basic	Population Density Difference	MySQL MSSQL Oracle
Easy	Basic	The Blunder	MySQL MSSQL Oracle
Easy	Basic	Top Earners	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 2	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 13	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 14	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 15	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 16	MySQL MSSQL Oracle
Easy	Basic	Weather Observation Station 17	MySQL MSSQL Oracle
Medium	Basic	Weather Observation Station 18	MySQL MSSQL Oracle
Medium	Basic	Weather Observation Station 19	MySQL MSSQL Oracle
Medium	Intermediate	Weather Observation Station 20	MySQL MSSQL Oracle

Basic Join

Difficulty	Skill	Challenge	Solution
Easy	Basic	Asian Population	MySQL
Easy	Basic	African Cities	MySQL
Easy	Basic	Average Population of Each Continent	MySQL
Medium	Intermediate	The Report	MySQL
Medium	Intermediate	Top Competitors	MySQL
Medium	Intermediate	Ollivander's Inventory	MySQL
Medium	Intermediate	Challenges	MySQL
Medium	Intermediate	Contest Leaderboard	MySQL

Advanced Join

Difficulty	Skill	Challenge	Solution
Medium	Intermediate	SQL Project Planning	MySQL
Medium	Intermediate	Placements	MySQL
Medium	Intermediate	Symmetric Pairs	MySQL
Hard	Intermediate	Interviews	MySQL
Hard	Advanced	15 Days of Learning SQL	MySQL

Alternative Queries

Difficulty	Skill	Challenge	Solution
Easy	Advanced	Draw The Triangle 1	MySQL
Easy	Advanced	Draw The Triangle 2	MySQL
Medium	Advanced	Print Prime Numbers	MySQL

Contact Information