Netflix SQL Interview Question for Data Scientists and Data Analysts (StrataScratch 9751)

Solution and walkthrough of a real SQL interview question for Data Scientist and Data Analyst technical coding interviews. This question was asked by Netflix and is called "Nominees Without An Oscar".

Playlists:

[arkyabagchi]

kudos to you..I was regularly following your leetcode SQL series and practicing queries & now I m able to crack the data science internship. A big shout out to your efforts

[mindyourrook]

I really like the way you explain the approach. I wish I can do the same in interviews. First of all under pressure I forget the most efficient way to get the output and worse is I fumble or poorly communicate the approach. Keep making such video Frederik 💯

[deepikagodavari]

select nominee, sum(case when winner =FALSE then 1 else 0 end) as unsuccesfullNominations from table
group by 1 order by 2 desc;

[ashokagraju]

How about this SELECT nominee,
count(nominee) as number_of_times_nominated
FROM oscar_nominees
WHERE winner = 'FALSE'
GROUP BY nominee
order BY count(nominee) desc;

[ayeoh]

Thinking this may also work, let me know what you think:

SELECT nominee, count(nominee) as nom
FROM oscar_nominations
Where Winner = 'FALSE'
group by nominee
Order by nom DESC