Google's SQL Question & Answer | Crack ANY Interview with this 3 Step Approach

In this video, we are going to see how to solve a SQL interview question "English, German, French, Spanish Speakers" asked at Google.

Topics Covered:
00:00 - Introduction
00:18 - Three Step Approach
02:10 - Understand the Inputs & Outputs
03:19 - Articulate the Solution Verbally
04:22 - Construct the Query Step by Step

#jovian #programming #sql #google #interviewquestions

[dinesh_k]

I almost got u till group by, that *having* part is really awesome, I was thinking of a complex approach, kind of nested query. Great explanation.

[anujsrivastava]

That approach is really making me solve complex questions. Thanks!

[wandat]

Thanks for this video, it was super helpful!

[blochspin]

why not HAVING COUNT(DISTINCT language) > 2; instead?