EASY SQL Leetcode Interview Questions | Practice

In this Video I will go with you through 9 Easy SQL Interview Questions on Leetcode. I will solve them in excruciating detail and use minimal editing so that you can follow all of my thought patterns.

Here you find the Leetcode problems:
____________________________________________

SUBSCRIBE!
Do you want to understand how to solve SQL Problems in every detail? That's what my channel is about. When I was younger I thought I could never program because it looked way too difficult. The truth is that it takes time but with some patience anybody can do it! Follow me along and get better!
____________________________________________

SUPPORT MY CHANNEL

🙌The best way to support my channel right now is to give me a Super Thanks. You can do that by clicking thanks next to the title of the video. It is much appreciated!

____________________________________________

____________________________________________

00:00:00 Introduction
00:03:07 Game Play Analysis I
00:08:24 Customer Placing the Largest Number of Orders
00:21:25 Sales Person
00:31:46 Actors and Directors Who Cooperated At Least Three Times
00:44:57 Sales Analysis III
01:05:47 User Activity for the Past 30 Days I
01:18:17 Article Views I
01:22:15 Top Travellers
01:46:43 Group Sold Products By The Date

[rahulrajpoot]

Very great work bro. Please keep uploading the videos

[sabidhamu]

also at 1:15:00, we need to add filter count(distinct(userid))>1, they say in question if user logged once a in given day then he is considered active for that day

[jamaicaigot]

Hey, thanks for sharing! Helps me a lot! Are you in audea?

[sabidhamu]

why at 56:36 you r finding all products in 3rd, 4th, 2nd and excluding it. They have given in question all order in 1st quater. so sale_date between 1-1-2019 and 3-30-219 is good enough?

[rydmerlin]

It’s not highest order number it’s highest number of orders ie count