APDaga DumpBox : The Thirst for Learning...

HackerRank

SQL Question: BANK ACCOUNTS SUMMARY | MySQL Solution by APDaga

I came across a SQL question . Here I am providing my solution to the problem " Bank Accounts Summary ". It will help …

byAkshay Daga (APDaga) -May 01, 2022

HackerRank

HackerRank: SQL - All solutions (Basic Select, Advanced Select, Aggregation, Basic Join, Advanced Join, Alternative Queries)

I have tried to provide the complete solution with possible explanation to all SQL Practice problem on HackerRank .  While sol…

byAkshay Daga (APDaga) -April 22, 2021

HackerRank

HackerRank: [SQL Alternative Queries] (3/3) PRINT PRIME NUMBERS | declare, set, while, if, exists, substring in ms-sql

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 23, 2021

HackerRank

HackerRank: [SQL Alternative Queries] (2/3) DRAW THE TRIANGLE 2 | set, limit, mysql & ms-sql solutions

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 23, 2021

HackerRank

HackerRank: [SQL Alternative Queries] (1/3) DRAW THE TRIANGLE 1 | set, limit, mysql & ms-sql solutions

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 23, 2021

HackerRank

HackerRank: [SQL Advanced Join] (5/5) 15 DAYS OF LEARNING SQL | Sub-Query, datediff, distinct, count in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 22, 2021

HackerRank

HackerRank: [SQL Advanced Join] (4/5) INTERVIEWS | inner & left join, having, sum in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 22, 2021

HackerRank

HackerRank: [SQL Advanced Join] (3/5) SYMMETRIC PAIRS | cross join, having, union, exists in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 21, 2021

HackerRank

HackerRank: [SQL Advanced Join] (2/5) PLACEMENTS | inner join Students, Friends, Packages in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 21, 2021

HackerRank

HackerRank: [SQL Advanced Join] (1/5) SQL PROJECT PLANNING | cross join, datediff & Sub-Query in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 18, 2021

HackerRank

HackerRank: [SQL Basic Join] (8/8) CONTEST LEADERBOARD | inner join, having & Sub-Query in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 12, 2021

HackerRank

HackerRank: [SQL Basic Join] (7/8) CHALLENGES | inner join, having& Sub-Query in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 12, 2021

HackerRank

HackerRank: [SQL Basic Join] (6/8) OLLIVANDER'S INVENTORY | inner join, min & Sub-Query in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 12, 2021

HackerRank

HackerRank: [SQL Basic Join] (5/8) TOP COMPETITORS | having & inner join in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 12, 2021

HackerRank

HackerRank: [SQL Basic Join] (4/8) THE REPORT | case when & left join in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 11, 2021

HackerRank

HackerRank: [SQL Basic Join] (3/8) AVERAGE POPULATION OF EACH CONTINENT | floor, avg & inner join in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 10, 2021

HackerRank

HackerRank: [SQL Basic Join] (2/8) AFRICAN CITIES | distinct & inner join in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 10, 2021

HackerRank

HackerRank: [SQL Basic Join] (1/8) ASIAN POPULATION | inner join in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 10, 2021

HackerRank

HackerRank: [SQL Aggregation] (17/17) Weather Observation Station-20 | round, row_number, ceil, floor & '@' operator in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 07, 2021

HackerRank

HackerRank: [SQL Aggregation] (16/17) Weather Observation Station-19 | set, round, min, max, power & sqrt function in SQL

I started studying SQL from a very famous site -  HackerRank . Here I will try to provide multiple approaches & solutions to…

byAkshay Daga (APDaga) -March 07, 2021