Ashirr Kashyap
Ashirr Kashyap
  • 46
  • 22 917
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
มุมมอง: 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
How to create word clouds in Python?
มุมมอง 37ปีที่แล้ว
How to create word clouds in Python?
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

ความคิดเห็น

  • @bazzelrahman5879
    @bazzelrahman5879 หลายเดือนก่อน

    I didn't get the point of (specs=[[{"secondary_y: True}]]) How does that work? Please explain.

  • @UnrealAdi
    @UnrealAdi 2 หลายเดือนก่อน

    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!

    • @ashirrkashyap3849
      @ashirrkashyap3849 2 หลายเดือนก่อน

      Sure I’ll include this in the upcoming videos

  • @UnrealAdi
    @UnrealAdi 2 หลายเดือนก่อน

    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.

    • @ashirrkashyap3849
      @ashirrkashyap3849 2 หลายเดือนก่อน

      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.

    • @UnrealAdi
      @UnrealAdi 2 หลายเดือนก่อน

      @@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!

  • @MusicalShorts-hn1px
    @MusicalShorts-hn1px 2 หลายเดือนก่อน

    Video was helpful. Special thanks for adding the create command in description

  • @ankitsaxena565
    @ankitsaxena565 2 หลายเดือนก่อน

    Can I use row_number() because

    • @ashirrkashyap3849
      @ashirrkashyap3849 2 หลายเดือนก่อน

      You can

    • @Hope-xb5jv
      @Hope-xb5jv 2 หลายเดือนก่อน

      @@ashirrkashyap3849 According to me row_number is better instead of rank Reason ---- Any case (rare) if transaction date is same then rank logic fail

  • @DA_Guy123
    @DA_Guy123 2 หลายเดือนก่อน

    Nice work , keep it up 💯 Just now subscribed your channel

  • @pradeepvadlakonda007
    @pradeepvadlakonda007 3 หลายเดือนก่อน

    select rider_id,datediff(max(trip_date),min(trip_date)) as total_days from trips group by 1 having total_days>=2;

    • @ashirrkashyap3849
      @ashirrkashyap3849 3 หลายเดือนก่อน

      This will give the difference between the first and last trip, not the first and second trip

  • @tejaspise4638
    @tejaspise4638 3 หลายเดือนก่อน

    Good👍

  • @MusicalShorts-hn1px
    @MusicalShorts-hn1px 3 หลายเดือนก่อน

    You're videos are really helpful...Can you please add create and table creation and insert command in video description

    • @ashirrkashyap3849
      @ashirrkashyap3849 3 หลายเดือนก่อน

      Sure I’ll add this and update.

    • @ashirrkashyap3849
      @ashirrkashyap3849 3 หลายเดือนก่อน

      I have added the create table statement in a link provided in the description.

  • @user-nq3gn4qn9x
    @user-nq3gn4qn9x 3 หลายเดือนก่อน

    nice video, good work

  • @antonelapaoletti6218
    @antonelapaoletti6218 3 หลายเดือนก่อน

    Muchas gracias!! 🙌🙌

  • @MusicalShorts-hn1px
    @MusicalShorts-hn1px 3 หลายเดือนก่อน

    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

    • @ashirrkashyap3849
      @ashirrkashyap3849 3 หลายเดือนก่อน

      Thanks for the suggestion, I have added the sample table here: docs.google.com/spreadsheets/d/1vy7K_oqrG5PBpOLMKaR1vo0IuNMNRIyyrylDSl9RpUU/edit#gid=0

  • @finuture
    @finuture 3 หลายเดือนก่อน

    do you have something for line chart if I were to plot, clothes, electric etc as different lines?

    • @ashirrkashyap3849
      @ashirrkashyap3849 3 หลายเดือนก่อน

      Check out this video: th-cam.com/video/vTScJ6Xo_hQ/w-d-xo.html

  • @finuture
    @finuture 3 หลายเดือนก่อน

    Excellent one!

  • @samridhiswadha7543
    @samridhiswadha7543 7 หลายเดือนก่อน

    very well explained, thank you! :D

  • @mayukhdas3112
    @mayukhdas3112 11 หลายเดือนก่อน

    can i change the y axis in terms of percentage

    • @ashirrkashyap3849
      @ashirrkashyap3849 10 หลายเดือนก่อน

      You can just make changes in the initial dataframe before you make the plot

  • @mayukhdas3112
    @mayukhdas3112 11 หลายเดือนก่อน

    Hi , can you make a video on how to plot heatmaps, correlation graph and show their significance.

    • @ashirrkashyap3849
      @ashirrkashyap3849 10 หลายเดือนก่อน

      Sure I will add it to my pipeline

  • @costadematos
    @costadematos 11 หลายเดือนก่อน

    Very good!

  • @protimaranipaul7107
    @protimaranipaul7107 ปีที่แล้ว

    Hi nice I have a q

  • @Funnyvideos-vy6gz
    @Funnyvideos-vy6gz ปีที่แล้ว

    Hi sir please let me know how to do number formatting in line, bar and any chart ex:(.5 into 50%)

    • @ashirrkashyap3849
      @ashirrkashyap3849 ปีที่แล้ว

      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 = "%")

  • @carlossellsoto
    @carlossellsoto ปีที่แล้ว

    Amazing video. Thank you!

  • @bachinaganesh1891
    @bachinaganesh1891 ปีที่แล้ว

    how to add gaps between histogram bars

    • @ashirrkashyap3849
      @ashirrkashyap3849 ปีที่แล้ว

      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()

  • @TheMarcellopaolo
    @TheMarcellopaolo ปีที่แล้ว

    Thanks a lot! Really nice video and good idea to put the link to the code!!

  • @akcandlestick8948
    @akcandlestick8948 ปีที่แล้ว

    ashirr bhai is same programe ko desktop pc ya laptop par kaise use kare pls guide

    • @ashirrkashyap3849
      @ashirrkashyap3849 ปีที่แล้ว

      Anaconda navigator install krlo, usse ho jaega

  • @julianichagas
    @julianichagas ปีที่แล้ว

    Thank you!! 😁

  • @oshiga4life
    @oshiga4life ปีที่แล้ว

    THnaks

  • @dinukadilshan5877
    @dinukadilshan5877 ปีที่แล้ว

    Thank you for the clear and quick explanation.

  • @himanshupoddar1395
    @himanshupoddar1395 ปีที่แล้ว

    Creator of the dataset here. Thanks for using the dataset

  • @LuckyPanwar
    @LuckyPanwar ปีที่แล้ว

    Keep it up🎉

  • @LuckyPanwar
    @LuckyPanwar ปีที่แล้ว

    Bro you are doing great job, you helped to sort my office work 😂😂

  • @emirhanbilgic2475
    @emirhanbilgic2475 ปีที่แล้ว

    great tutorial, thank you!

  • @GauravDhage
    @GauravDhage ปีที่แล้ว

    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!

    • @ashirrkashyap3849
      @ashirrkashyap3849 ปีที่แล้ว

      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

    • @GauravDhage
      @GauravDhage ปีที่แล้ว

      @@ashirrkashyap3849 thank you so much brother

  • @sag7611
    @sag7611 2 ปีที่แล้ว

    Thanks a lot. It was so useful!!

    • @ashirrkashyap3849
      @ashirrkashyap3849 2 ปีที่แล้ว

      Thank you, I'll try and make more of such useful content.

  • @musakhan9779
    @musakhan9779 2 ปีที่แล้ว

    Why it is so difficult to get freelance work as a data analyst

    • @ashirrkashyap3849
      @ashirrkashyap3849 2 ปีที่แล้ว

      Well because freelancing as a data scientist/analyst is very competitive, there are a lot of highly skilled data scientists out there.

    • @musakhan9779
      @musakhan9779 2 ปีที่แล้ว

      @@ashirrkashyap3849 What do you recommend which niche is good for getting remote work?

    • @ashirrkashyap3849
      @ashirrkashyap3849 2 ปีที่แล้ว

      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.