- 46
- 22 917
Ashirr Kashyap
เข้าร่วมเมื่อ 29 มิ.ย. 2014
That Indian guy in that Tech tutorial.
Google | SQL Interview Problem | Closest Scores
Ready to ace your Google SQL interview?
In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Google.
Detailed step-by-step explanation regarding the solution approach and the code.
If you find this video helpful, please like, comment, and subscribe for more tech interview prep content.
Data Schema & Create Table Statement:
docs.google.com/spreadsheets/d/1vy7K_oqrG5PBpOLMKaR1vo0IuNMNRIyyrylDSl9RpUU/edit?gid=1968506308#gid=1968506308
In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Google.
Detailed step-by-step explanation regarding the solution approach and the code.
If you find this video helpful, please like, comment, and subscribe for more tech interview prep content.
Data Schema & Create Table Statement:
docs.google.com/spreadsheets/d/1vy7K_oqrG5PBpOLMKaR1vo0IuNMNRIyyrylDSl9RpUU/edit?gid=1968506308#gid=1968506308
มุมมอง: 35
วีดีโอ
Google | SQL Interview Problem | Rank The Departments
มุมมอง 122 หลายเดือนก่อน
Ready to ace your Google SQL interview? In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Google. Detailed step-by-step explanation regarding the solution approach and the code. If you find this video helpful, please like, comment, and subscribe for more tech interview prep content. Data Schema & Create Table Statement: docs.google.com/spreadsheets/d/...
Amazon | SQL Interview Problem | Fetch Manager With Largest Team
มุมมอง 292 หลายเดือนก่อน
Ready to ace your Amazon SQL interview? In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Amazon. Detailed step-by-step explanation regarding the solution approach and the code. If you find this video helpful, please like, comment, and subscribe for more tech interview prep content. Data Schema and Create Table Statement: docs.google.com/spreadsheets/...
Amazon | SQL Interview Problem | Fetch Second Highest Salary
มุมมอง 252 หลายเดือนก่อน
Ready to ace your Amazon SQL interview? In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Amazon. Detailed step-by-step explanation regarding the solution approach and the code. If you find this video helpful, please like, comment, and subscribe for more tech interview prep content. Data Schema & Create Table Statement: docs.google.com/spreadsheets/d/...
Amazon | SQL Interview Problem | Lifetime Products Bought
มุมมอง 882 หลายเดือนก่อน
Ready to ace your Amazon SQL interview? In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Amazon. Detailed step-by-step explanation regarding the solution approach and the code. If you find this video helpful, please like, comment, and subscribe for more tech interview prep content. Data Schema & Create Table Statement: docs.google.com/spreadsheets/d/...
Google | SQL Interview Problem | Finding Power Users
มุมมอง 633 หลายเดือนก่อน
Ready to ace your Google SQL interview? In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Google . Detailed step-by-step explanation regarding the solution approach and the code. If you find this video helpful, please like, comment, and subscribe for more tech interview prep content. Data Schema & Create Table Query: docs.google.com/spreadsheets/d/1vy...
Amazon | SQL Interview Problem | Cumulative Sum of Orders
มุมมอง 503 หลายเดือนก่อน
Ready to ace your Amazon SQL interview? In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Amazon. Detailed step-by-step explanation regarding the solution approach and the code. If you find this video helpful, please like, comment, and subscribe for more tech interview prep content. Data Schema & Create Table Query: docs.google.com/spreadsheets/d/1vy7...
Amazon | SQL Interview Problem | Top-Two Grossing Products Across Category
มุมมอง 403 หลายเดือนก่อน
Ready to ace your Amazon SQL interview? In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Amazon. Detailed step-by-step explanation regarding the solution approach and the code. If you find this video helpful, please like, comment, and subscribe for more tech interview prep content. Data Schema & Create Table Query: docs.google.com/spreadsheets/d/1vy7...
Amazon | SQL Interview Problem | Fetching Average Rating
มุมมอง 453 หลายเดือนก่อน
Ready to ace your Amazon SQL interview? In this video, we'll dive deep into one of the most commonly asked SQL interview questions at Amazon. Detailed step-by-step explanation regarding the solution approach and the code. If you find this video helpful, please like, comment, and subscribe for more tech interview prep content. Data Schema & Create Table Query: docs.google.com/spreadsheets/d/1vy7...
Uber | SQL Interview Question | Find the Click-to-Book Ratio
มุมมอง 723 หลายเดือนก่อน
Ready to ace your Uber SQL interview? In this video, we'll dive deep into the most commonly asked SQL interview questions at Uber. Detailed explanations, practical examples, and real-world scenarios to help you solve business problems like a pro. Don't miss our expert tips on what Uber looks for in a candidate! If you find this video helpful, please like, comment, and subscribe for more tech in...
Uber | SQL Interview Question | Find the trip-gap
มุมมอง 3273 หลายเดือนก่อน
Ready to ace your Uber SQL interview? In this video, we'll dive deep into the most commonly asked SQL interview questions at Uber. Detailed explanations, practical examples, and real-world scenarios to help you solve business problems like a pro. Don't miss our expert tips on what Uber looks for in a candidate! If you find this video helpful, please like, comment, and subscribe for more tech in...
Uber | SQL Interview Question | Fetch The Third Transaction
มุมมอง 4533 หลายเดือนก่อน
Ready to ace your Uber SQL interview? In this video, we'll dive deep into the most commonly asked SQL interview questions at Uber. Detailed explanations, practical examples, and real-world scenarios to help you solve business problems like a pro. Don't miss our expert tips on what Uber looks for in a candidate! If you find this video helpful, please like, comment, and subscribe for more tech in...
How to Read multiple files in python at once?
มุมมอง 408ปีที่แล้ว
Are you tired of opening and reading multiple files one by one in Python? 📂 In this comprehensive tutorial, we'll show you how to streamline your file handling process by reading multiple files at once! 🚀 Code link: drive.google.com/drive/folders/1XEk-jleAu1vxC4uyh4P65BksBEQnvwbl?usp=drive_link
The most IN-DEMAND SKILLS in Data/Business Analytics
มุมมอง 71ปีที่แล้ว
A discussion on the most in-demand skills in the data/business analytics space. Slide link: docs.google.com/presentation/d/1SJtykMarBE1q2BDOXjhb8fepW3wWDhBy/edit?usp=sharing&ouid=103871778307677579274&rtpof=true&sd=true
How to calculate MOM Customer Retention using Python?
มุมมอง 203ปีที่แล้ว
A tutorial on calculating month on month customer retention using Python. Data and code link: drive.google.com/drive/folders/1GHsLT_9VpqVYceUbvvjOGtHOqTjw5TZi?usp=sharing
5 Must Have Projects In Your Data Science Portfolio
มุมมอง 109ปีที่แล้ว
5 Must Have Projects In Your Data Science Portfolio
Net Promoter Score | How to calculate in Excel & Python?
มุมมอง 182ปีที่แล้ว
Net Promoter Score | How to calculate in Excel & Python?
Getting started as a Data Science Freelancer
มุมมอง 48ปีที่แล้ว
Getting started as a Data Science Freelancer
Facebook Prophet Time Series Forecast | Python Tutorial
มุมมอง 164ปีที่แล้ว
Facebook Prophet Time Series Forecast | Python Tutorial
Mastering E-Commerce Success: Essential KPIs Every Business Must Track
มุมมอง 36ปีที่แล้ว
Mastering E-Commerce Success: Essential KPIs Every Business Must Track
Funnel Chart | Python Plotly Tutorial #18
มุมมอง 8232 ปีที่แล้ว
Funnel Chart | Python Plotly Tutorial #18
Waterfall Chart | Python Plotly Tutorial #17
มุมมอง 1K2 ปีที่แล้ว
Waterfall Chart | Python Plotly Tutorial #17
Pizza-Hut Store Performance | Business Problem | Data Science Interview
มุมมอง 452 ปีที่แล้ว
Pizza-Hut Store Performance | Business Problem | Data Science Interview
Dual-Axis Combo Chart | Python Plotly Tutorial #16
มุมมอง 1.7K2 ปีที่แล้ว
Dual-Axis Combo Chart | Python Plotly Tutorial #16
Freelance Data Science Project | Textual EDA | Part 2
มุมมอง 222 ปีที่แล้ว
Freelance Data Science Project | Textual EDA | Part 2
Freelance Data Science Project | Textual EDA | Part 1
มุมมอง 232 ปีที่แล้ว
Freelance Data Science Project | Textual EDA | Part 1
Customer Segmentation | Python Implementation | Part 2
มุมมอง 2462 ปีที่แล้ว
Customer Segmentation | Python Implementation | Part 2
Customer Segmentation | Case Study | Part 1
มุมมอง 6402 ปีที่แล้ว
Customer Segmentation | Case Study | Part 1
Zomato Case Study | Solution Implementation | Part 2
มุมมอง 1272 ปีที่แล้ว
Zomato Case Study | Solution Implementation | Part 2
I didn't get the point of (specs=[[{"secondary_y: True}]]) How does that work? Please explain.
I have a suggestion, Could you please show the final output after you've generated the final query? It is helpful to see how the output looks like after the execution of the final query. Cheers man!
Sure I’ll include this in the upcoming videos
The Amazon Interview questions you are posting on the channel recently, are they recently asked questions? And for which experience level? Thanks man, great content.
Some of them have been asked recently that I gotta know through my connection, some I’ve got through researching online, these questions are for 1-6 years of experience.
@@ashirrkashyap3849 Brilliant! If you could pin a comment to each of your videos suggesting the recency and the experience level of the asked question, that would be phenominal!
Video was helpful. Special thanks for adding the create command in description
Can I use row_number() because
You can
@@ashirrkashyap3849 According to me row_number is better instead of rank Reason ---- Any case (rare) if transaction date is same then rank logic fail
Nice work , keep it up 💯 Just now subscribed your channel
Thanks
select rider_id,datediff(max(trip_date),min(trip_date)) as total_days from trips group by 1 having total_days>=2;
This will give the difference between the first and last trip, not the first and second trip
Good👍
Thanks
You're videos are really helpful...Can you please add create and table creation and insert command in video description
Sure I’ll add this and update.
I have added the create table statement in a link provided in the description.
nice video, good work
Thanks✨
Muchas gracias!! 🙌🙌
De nada ✨
Thanks for posting these interview problems.....would've been more helpful if you would've added table schema/structure in description so one could practice along with....just watching these videos doesn't help much
Thanks for the suggestion, I have added the sample table here: docs.google.com/spreadsheets/d/1vy7K_oqrG5PBpOLMKaR1vo0IuNMNRIyyrylDSl9RpUU/edit#gid=0
do you have something for line chart if I were to plot, clothes, electric etc as different lines?
Check out this video: th-cam.com/video/vTScJ6Xo_hQ/w-d-xo.html
Excellent one!
very well explained, thank you! :D
Glad it was helpful!
can i change the y axis in terms of percentage
You can just make changes in the initial dataframe before you make the plot
Hi , can you make a video on how to plot heatmaps, correlation graph and show their significance.
Sure I will add it to my pipeline
Very good!
Hi nice I have a q
What's your q?
Hi sir please let me know how to do number formatting in line, bar and any chart ex:(.5 into 50%)
You can simply multiply 0.5*100= 50 and, use the following syntax to add the percentage sign for plotly graphs: fig.update_layout(yaxis_ticksuffix = "%")
Amazing video. Thank you!
Glad you liked it!
how to add gaps between histogram bars
Use the following: fig = px.histogram(df, x='Weight',nbins=9,height=600,width=900) fig.update_layout(bargap=0.30) #You can add gaps using this statement fig.show()
Thanks a lot! Really nice video and good idea to put the link to the code!!
ashirr bhai is same programe ko desktop pc ya laptop par kaise use kare pls guide
Anaconda navigator install krlo, usse ho jaega
Thank you!! 😁
THnaks
Thank you for the clear and quick explanation.
Glad it was helpful!
Creator of the dataset here. Thanks for using the dataset
Thank you for creating the dataset😇
Keep it up🎉
Bro you are doing great job, you helped to sort my office work 😂😂
great tutorial, thank you!
Thank you so much for video, I have one query - I want to color decreasing bars in different shades of red i.e. for first decreasing bar I want dark red and for second decreasing bar I want lighter red and others like increasing and absolute bars I want default colors, how can I do that? please help me!
I personally haven't implemented what you've mentioned in your query but i believe the following should resolve it: stackoverflow.com/questions/64295425/how-to-set-different-colors-for-bars-in-a-plotly-waterfall-chart
@@ashirrkashyap3849 thank you so much brother
Thanks a lot. It was so useful!!
Thank you, I'll try and make more of such useful content.
Why it is so difficult to get freelance work as a data analyst
Well because freelancing as a data scientist/analyst is very competitive, there are a lot of highly skilled data scientists out there.
@@ashirrkashyap3849 What do you recommend which niche is good for getting remote work?
Every niche is competitive, you need to just select a niche and increase your competency in that niche. The more specialized skill you'll have the easier it would be getting remote work.