One of the best websites for preparing for Data Science and Analytics interviews, being using it for quite sometime, highly recommend to everyone 👏🙂
@LukeBarousse2 жыл бұрын
00:20 The bank account screen... "$no money bruh".... I died 😂🤣 More skits like this Shashank!!
@ShashankData2 жыл бұрын
Learning from the best ;)
@danielhrdy25922 жыл бұрын
Soon it's gonna be a year watching you, it's great to see both of us grow in the data field and you in the video production!
@ShashankData2 жыл бұрын
Thank you so much Daniel! Let's keep crushing it
@airamalhotra74742 жыл бұрын
Cool intro Shashank! I liked knowing about your thinking process while framing a complex query. Also, I learnt more from your error corrections.. it helped me concentrate better. I would have zoned out midway had you got all three questions right straight away. All in all great video!
@knwr2 жыл бұрын
I found what I believe to be a mistake in the second question, however it did accept your answer so maybe I am the one who is misinterpretting. When you create your CTE table, only nationality is included and not "host_id". This could return unintended results. For example, if the reviewer gives 10 different USA citizens one 10/10 review each, but also gives 1 single Australian 5 separate 10/10 reviews, the query will return "USA" as the favorite nationality. However, the question asks: "What is the nationality of the _favorite host_ " which in this scenario should be Australian. I believe one more Window Function is required to determine which guest receives the most 10/10, and then the nationality of that guest is the answer. This query then results in duplicate results since there are ties (Ex. from_user 1 gave 2 Brazilian hosts 4 10/10 reviews each), so the duplicates must be removed as requested (I used group by). If you have time, let me know what you think. Here's what I believe the correct query is for what the question asks: SELECT from_user, nationality, rev_count FROM ( SELECT COUNT(review_score) AS rev_count, from_user, nationality, host_id, MAX(COUNT(review_score)) OVER (PARTITION BY from_user) AS max_reviews FROM ( SELECT review_score, from_user, nationality, host_id, MAX(review_score) OVER (PARTITION BY from_user) as max_score FROM airbnb_reviews LEFT JOIN airbnb_hosts ON airbnb_reviews.to_user = airbnb_hosts.host_id WHERE from_type = 'guest' ) a WHERE review_score = max_score GROUP BY from_user, host_id, nationality ) b WHERE rev_count = max_reviews GROUP BY from_user, nationality Also thanks for the high quality material. I recently found your channel and really enjoy the content. 👍
@valiuddinqureshi64922 жыл бұрын
I love watching your content. Looking forward for more skits in the upcoming videos. Gives that entertainment punch to the learning.
@arielchocobar9608 Жыл бұрын
Shashank I keep watching your videos, this is what I want to do with my life, data science. you could be a celebrity in the data science world and we your biggest fans hahhha. but seriously thanks for all the efforts you make to teach us.
@anggipermanaharianja61222 жыл бұрын
for medium question [Favorite Host Nationality] we could also use rank() window function in our CTE, simpler and clearer like this with cte as (select ar.from_user as user_id, ar.to_user, ar.review_score, ah.nationality as nationality, rank() over(partition by ar.from_user order by ar.review_score desc) as rank_ from airbnb_reviews as ar left join airbnb_hosts as ah on ar.to_user = ah.host_id where from_type='guest') select distinct user_id, nationality from cte where rank_ = 1
@ShashankData2 жыл бұрын
Great solution!
@taz23922 жыл бұрын
Guys I work full time 10-7pm with 3 kids and 41 years old. I’m the IT guy in the office with no degree and I know if I ever got fired I’d have to start again as I’ve only been paid more and more out of loyalty. I finally have some time to study and I would love to analyse data and help make reports by running scripts and presenting them. I thought I’d start with learning SQL from Colt Steele udemy course. Was wondering what your thoughts were as I have limited time to study and learn. Thank you.
@tuandino69902 жыл бұрын
Nice intro. Thanks for your work shashank
@aidanthompson505310 ай бұрын
CTRL forward slash to comment out multiple lines of code
@yasuke820911 ай бұрын
>= 3 because it will still bring up beds that are more than 3
@taz23922 жыл бұрын
One of the best KZbinrs around. Thank you
@luigiruiz8022 жыл бұрын
Thanks for the examples!
@jotaemedlf57772 жыл бұрын
That intro was fire🔥
@ShashankData2 жыл бұрын
Thank u so much!
@saloriasaxon73232 жыл бұрын
Yeah...that skit!🤣🤣🤣 You, Luke and Alex are great!!
@alvarochinchayan60352 жыл бұрын
Really can't find content more valuable than this. Appreciate all your time and effort Shashank -- keep up the good work!
@ShashankData2 жыл бұрын
Of course Alvaro! I have a ton of fun making these!
@asian15992 жыл бұрын
at 19:12 could you use DISTINCT on nationality instead of group by 1, 2?
@ShashankData2 жыл бұрын
Yes that would be an option as well!
@keifer78132 жыл бұрын
10:15 Isn't the from_user column the reviewer, not the guest? The from_type column tells you if that review was left by a guest or host. Correct me if I'm wrong
@maisarahmonier22562 жыл бұрын
13:38 why did he need to alias this????? can someone explain the error?
@albertbarber12032 жыл бұрын
Whats this landing page he has when opening google? How do I get it?
@aces84812 ай бұрын
bro when you're unemployed that avocado toast becomes a luxury 😂
@JustinInBlack Жыл бұрын
funny outro; thankss
@lekanfagbuyi7963 Жыл бұрын
This video intro is everything 😂
@keifer78132 жыл бұрын
That skit was great lmao
@paulp44752 жыл бұрын
i gave a like just for the intro
@ShashankData2 жыл бұрын
Thank you so much! I wasn't sure how well it would go over
@michael_bryant2 жыл бұрын
$no money bruh
@halowaffles2 жыл бұрын
"broke bois dont get points" Me: :')
@Dota2seconds2 жыл бұрын
strike par jayegi Bhaai!
@Dota2seconds2 жыл бұрын
music hataoooo
@abdallahelra3y1182 жыл бұрын
You watch anime :)🖤
@FunkyPretzel0911 Жыл бұрын
with temp as (select a.from_user,b.nationality,max(a.review_score) as top_score,dense_rank() over(partition by A.from_user order by a.review_score desc) as rank from airbnb_reviews a join airbnb_hosts b on a.to_user=b.host_id where a.from_type='guest' group by a.from_user,b.nationality,a.review_score order by from_user,top_score desc ) select t.from_user,t.nationality,t.top_score from temp t where t.rank=1; CORRECT ME IF I'M WRONG FOR 2ND QUESTION
@Abdullah_Khaled Жыл бұрын
Amazing video, but I'm wondering why you would use group by clause even if no aggr. function in the select statement (especially when using subquery) ?
@EdDy2419072 жыл бұрын
Haha love the intro!
@KNNPodcast2 жыл бұрын
That avo toast be hittin hard
@ShashankData2 жыл бұрын
Basically why I'll be renting for the rest of my life 🤣
@bapu462 Жыл бұрын
The GROUP BY clause was not necessary for the 3rd question, because there are no aggregate functions being used in the query.
@abdel10592 жыл бұрын
hello your channel really motive me to start learning data analyst and i started but can you make a video about how can a fresher data analyst get a job remotely from anywhere in the world with a company if that happens or not a ask that because in my country all data analyst should have a degree from university and i don't the only way that i get job is freelancer or hired from a company remotely i think you understand my question and how to become really attractive to be hired thx you sorry for my english
@sjord588 Жыл бұрын
Thank you so much for making this video! :)
@helloworld2696 Жыл бұрын
i also find 2nd more difficult than 3rd :)
@humanalltoohuman Жыл бұрын
"No money bruh" I felt that.
@alfredalonzo54562 жыл бұрын
I learned a big deal, thanks man
@RiiicoSupreme2 жыл бұрын
You are the greatest man
@Ninjawwmmmmmmm2 жыл бұрын
Hey Shashank don’t mind me but you spelled “avocado” wrong 😉. That intro was fire nevertheless!
@ShashankData2 жыл бұрын
LOLOLOLOL great catch!
@Alex-yy6oi2 жыл бұрын
love your videos!! Do you have any videos on managing packages in python?
@ShashankData2 жыл бұрын
Thank you so much Alex! Here is a link to that video: kzbin.info/www/bejne/gqjEq3uLoLpof7M
@theJYC2 жыл бұрын
Loved the intro skit Shashank! Your editing skills are getting stronger by day (secondary to your data skills ofc) 🙌🏼