Hackerrank SQL Solutions | ALL EASY Hackerrank SQL Problems

Watch all Easy Hackerrank SQL Problems solved in this video.
____________________________________________

SUBSCRIBE!
Do you want to understand how to solve SQL Problems in every detail? That's what my channel is about. When I was younger I thought I could never program because it looked way too difficult. The truth is that it takes time but with some patience anybody can do it! Follow me along and get better!
____________________________________________

SUPPORT MY CHANNEL

🙌The best way to support my channel right now is to give me a Super Thanks. You can do that by clicking thanks next to the title of the video. It is much appreciated!

____________________________________________

____________________________________________

0:00 Revising the Select Query I
1:46 Revising the Select Query II
2:56 Select All
3:31 Select by ID
4:09 Japanese Cities' Attributes
4:53 Japanese Cities' Names
5:37 Weather Observation Station 1
6:17 Weather Observation Station 3
11:01 Weather Observation Station 4
13:13 Weather Observation Station 5
18:33 Weather Observation Station 6
21:50 Weather Observation Station 7
23:11 Weather Observation Station 8
30:25 Weather Observation Station 9
33:22 Weather Observation Station 10
34:38 Weather Observation Station 11
36:56 Weather Observation Station 12
41:09 Higher Than 75 Marks
45:49 Employee Name
47:19 Employee Salaries
52:13 Type of Triangle
1:12:56 Revising Aggregations - The Count Function
1:14:32 Revising Aggregations - The Sum Function
1:15:37 Revising Aggregations - Averages
1:16:37 Average Population
1:17:24 Japan Population
1:18:10 Population Density Difference
1:19:09 The Blunder
1:34:50 Top Earners
1:51:21 Weather Observation Station 2
1:57:02 Weather Observation Station 13
1:59:20 Weather Observation Station 14
2:00:55 Weather Observation Station 15
2:13:08 Weather Observation Station 16
2:14:30 Weather Observation Station 17
2:19:16 Asian Population
2:21:03 African Cities
2:22:45 Average Population of Each Continent
2:28:56 Draw The Triangle 1
2:37:02 Draw The Triangle 2

[samuelnyarko]

As a newbie in SQL, learning on my own, seeing you try and not getting it the first time some of the time made me not useless as some of the pros even need googles help sometimes. Cant say thank you enough Sir.

[purinnbeau]

There is something strangely satisfying about hearing you say "And we got it!" every time you solve a problem. Thanks for the awesome video!!

[purushottamgupta]

I like the hit and trial approach. You started step by step in an incremental manner to land upon the right solution. kudos

[ramavenkatesh]

This is really helpful! thanks for the great video :)

[ikramali]

really helpful! thanks for the great video :)
hope you post more videos on sql

[vahidtyagi]

this is really helpful . it is like we are doing same mistake

[garima]

Thanks man really u have a great teaching skills...beacuse if in questions does not run you took the help from Google and and also used your mind....and run the query...thanks again man

[chandrashekharmuktapur]

FOR THE Weather Observation Station 5 QUESTION.. IN THE QUERY YOU HAD USED GROUP BY CLAUSE. SINCE THERE IS NO AGGREGATION FUNCTION USED IN QUERY THEN WHY WE NEED TO USE GROUP BY CLAUSE IN THE QUERY. COULD YOU PLEASE EXPLAIN.

[anime_sensei_squad]

This is so much helpful. Please keep coming with SQL videoes

[sid-harthsid-harth]

sir you missed observation 18
and query for observation 18 is
SELECT CASE WHEN g.grade < 8 THEN NULL ELSE s.name END as name,
g.grade, s.marks
FROM students AS s
INNER JOIN grades AS g
ON s.marks BETWEEN g.min_mark AND g.max_mark
ORDER BY g.grade DESC, s.name;

[tasyatri]

Hai i still can’t understand why you put 10 on syntax DECIMAL(10, 4)? Could you give the explain