Learn How to Solve SQL Interview Problem for Data Science 

This is objectively beautiful. The fact that you do not *act* like u know everything is honestly very inspiring to us, the new folk. Most other creators would just go through the problem, explaining every step(as if it's any helpful). The spontaneity of it is amazing. I wish more people would do that.

Very useful! I'm almost done with Google's Data Analytics course and am getting ready to practice for the SQL and programming language exams. I will join the data analytics industry soon, Thanks for the contents.

I love it that you still showed transparency and the fact that you posted this video that it’s okay to take your time to figure it out and everyone goes through it btw i’m new to data analytics completing google course and this was very helpful!

Been loving your content! Loved this addition! It's refreshing to see how others problem solve!

Your video made me understand that we do simple mistakes and it's okay irrespective of the experience we posses... Also the way you solved those two questions helps users to increase their interest in learning SQL as it was easy to understand. Thank you.

For query 1 I did it as below and I think it was easier than using group by clause. I also didn't type ASC because that's default. And I used limit instead of another criteria for where SELECT DISTINCT year_rank, group_name, song_name FROM billboard_top_100_year_end WHERE year = 2010 ORDER BY year_rank LIMIT 10;

You helped me so much by watching you doing mistakes.Thank you Sundas!

I'm in the middle of data analytics course from Google they introduced me to sql and bigquery I'm just curious about running my first queries and then you upload a video your content is really helpful and understandable and the Sql thing look easy to me i don't why?

Hi, could you recommend projects for beginners to understand what a data scientist actually does, an overview (maybe on kaggle)? Sometimes I feel that each company defines it in its own way. I would like to see if this is the right fit for me. Thanks for your vid!

Hi sundas.. first of all thanks for all these awesome content about data science...can you make a video on OSSU data science path in github...they have laid a entire roadmap to follow for data science enthusiasts who can be even a newbie in this field

For question one, it’s easy to output the song name uniquely, just type DISTINCT before the song_name, no need for a GROUP BY.

Could you please make statistics for data science videos?

Mam, I need help in making roadmap for being Applied Scientiest. Not able to find much quality information on the same. Would you like to please make a video on the same for non-tech background one. Or even, please comment some apt resources as per you so that I might try to make it myself and later get reviewed by you and other industry professionals/mentors working on similar roles .

Nice

Heyy... Well I'm not very good in SQL. For the 2nd problem, i used these codes and my answer is right select business_name, review_text, cool from yelp_reviews Where cool = 10 Is this the right way to answer?

I'm not so experienced with SQL so I try to run away from Windows Functions as much as possible, so all my respect to you, Sundas! This lead me to a simpler solution (in my personal opinion) just using a subquery, but no temporary tables, no joins, no windows function. SELECT business_name, review_text, SUM(cool) FROM yelp_reviews GROUP BY business_name, review_text HAVING SUM(cool) = (SELECT SUM(cool) FROM yelp_reviews GROUP BY business_name, review_text ORDER BY SUM(cool) DESC LIMIT 1) ORDER BY SUM(cool) DESC;

Regarding the second question, there is 2 simpler ways to solve it: -First: WITH maxCool AS( SELECT MAX(cool) as CoolVotesMAX FROM yelp_reviews ) SELECT business_name, review_text FROM yelp_reviews WHERE cool = (SELECT CoolVotesMAX FROM maxCool) -Second: WITH maxCool AS( SELECT business_name, review_text, cool, DENSE_RANK() OVER(ORDER BY cool DESC) as Rk FROM yelp_reviews ) SELECT business_name, review_text FROM maxCool WHERE rk = 1

for Query 2 solution select business_name, review_text, max(cool _votes) from yelp_reviews; group by review_text; try this

Niiiiiiiiiice!! I think you will be interested in Promo*SM.