07Agarg/HackerRank_Solutions

My Solutions to HackerRank Practice Questions on SQL, Python, and Algorithms

Solutions to HackerRank Problems

SQL

Basic Select

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

Advanced Select

Challenge	Solution
Type of Triangle	MySolution
The PADS	MySolution
Binary Tree Nodes	MySolution
New Companies	MySolution

Aggregation

Challenge	Solution
Revising Aggregations - The Count Function	MySolution
Revising Aggregations - The Sum Function	MySolution
Revising Aggregations - Averages	MySolution
Average Population	MySolution
Japan Population	MySolution
Population Density Difference	MySolution
The Blunder	MySolution
Top Earners	MySolution
Weather Observation Station 2	MySolution
Weather Observation Station 13	MySolution
Weather Observation Station 14	MySolution
Weather Observation Station 15	MySolution
Weather Observation Station 16	MySolution
Weather Observation Station 17	MySolution
Weather Observation Station 18	MySolution
Weather Observation Station 19	MySolution

Basic Join

Challenge	Solution
Asian Population	MySolution
African Cities	MySolution
Average Population of Each Continent	MySolution
The Report	MySolution
Top Competitors	MySolution
Challenges	MySolution

Python

Introduction

Challenge	Solution
Say "Hello, World!" With Python	MySolution
Python If-Else	MySolution
Arithmetic Operators	MySolution
Python: Division	MySolution
Loops	MySolution
Write a function	MySolution
Print Function	MySolution

Basic Data Types

Challenge	Solution
List Comprehensions	MySolution
Find the Runner-Up Score!	MySolution
Nested Lists	MySolution
Finding the percentage	MySolution
Lists	MySolution
Tuples	MySolution

Strings

Challenge	Solution
sWAP cASE	MySolution
String Split and Join	MySolution
What's Your Name?	MySolution
Mutations	MySolution
Find a string	MySolution
String Validators	MySolution
Text Alignment	MySolution
Text Wrap	MySolution
Capitalize!	MySolution

Sets

Challenge	Solution
Introduction to Sets	MySolution
Symmetric Difference	MySolution
No Idea!	MySolution
Set .add()	MySolution
Set .discard(), .remove() & .pop()	MySolution
Set .union() Operation	MySolution
Set .intersection() Operation	MySolution
Set .difference() Operation	MySolution
Set .symmetric_difference() Operation	MySolution
Set Mutations	MySolution
The Captain's Room	MySolution
Check Subset	MySolution
Check Strict Superset	MySolution

Math

Challenge	Solution
Polar Coordinates	MySolution
Mod Divmod	MySolution
Power - Mod Power	MySolution
Integers Come In All Sizes	MySolution
Triangle Quest	MySolution
Triangle Quest 2	MySolution

Itertools

Challenge	Solution
itertools.product()	MySolution
itertools.permutations()	MySolution
itertools.combinations()	MySolution
itertools.combinations_with_replacement()	MySolution
Compress the String!	MySolution
Iterables and Iterators	MySolution
Maximize It!	MySolution

Collections

Challenge	Solution
collections.Counter()	MySolution
DefaultDict Tutorial	MySolution
Collections.namedtuple()	MySolution
Collections.deque()	MySolution
Company Logo	MySolution
Collections.OrderedDict()	MySolution
Piling Up!	MySolution
Word Order	MySolution

Date and Time

Challenge	Solution
Calendar Module	MySolution
Time Delta	MySolution

Exceptions and Errors

Challenge	Solution
Exceptions	MySolution

Built-Ins

Challenge	Solution
Zipped!	MySolution
Python Evaluation	MySolution
Athlete Sort	MySolution
Any or All	MySolution
ginortS	MySolution

Regex and Parsing

Challenge	Solution
Detect Floating Point Number	MySolution
Re.split()	MySolution
Group(), Groups() & Groupdict()	MySolution
Re.findall() & Re.finditer()	MySolution
Re.start() & Re.end()	MySolution
Validating phone numbers	MySolution
Validating and Parsing Email Addresses	MySolution

Python Functionals

Challenge	Solution
Map and Lambda Function	MySolution
Validating Email Addresses With a Filter	MySolution
Reduce Function	MySolution

Numpy

Challenge	Solution
Arrays	MySolution
Shape and Reshape	MySolution
Transpose and Flatten	MySolution
Concatenate	MySolution
Zeros and Ones	MySolution
Eye and Identity	MySolution
Array Mathematics	MySolution
Floor, Ceil and Rint	MySolution
Sum and Prod	MySolution
Min and Max	MySolution
Mean, Var, and Std	MySolution
Dot and Cross	MySolution
Inner and Outer	MySolution
Polynomials	MySolution
Linear Algebra	MySolution