Skip to content

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

Notifications You must be signed in to change notification settings

07Agarg/HackerRank_Solutions

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation


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