Trang Ng

Data manipulation with Pandas Article Views, Invalid Tweets, Special Bonus | Leetcode

11:13

Data manipulation with Pandas Article Views, Invalid Tweets, Special Bonus | Leetcode

Жыл бұрын

Basic Join Contest Leaderboard & Top Competitors HackerRank Solution

15:45

Basic Join Contest Leaderboard & Top Competitors HackerRank Solution

Жыл бұрын

Basic Join with Case When HackerRank Solution

7:26

Basic Join with Case When HackerRank Solution

Жыл бұрын

Advanced Join with Binary Tree Nodes & New Company HackerRank Solution

10:09

Advanced Join with Binary Tree Nodes & New Company HackerRank Solution

Жыл бұрын

Advanced Select with The PADS HackerRank Solution

9:43

Advanced Select with The PADS HackerRank Solution

Жыл бұрын

183. Customers Who Never Order with Pandas | Leetcode

5:06

183. Customers Who Never Order with Pandas | Leetcode

Жыл бұрын

1757. Recyclable and Low Fat Products with Pandas | Leetcode

2:53

1757. Recyclable and Low Fat Products with Pandas | Leetcode

Жыл бұрын

595. Big Countries with Pandas | Leetcode

4:49

595. Big Countries with Pandas | Leetcode

Жыл бұрын

Leetcode SQL 50 | 1517-1327 Find Users With Valid E-Mails & List the Products Ordered Solution

9:16

Leetcode SQL 50 | 1517-1327 Find Users With Valid E-Mails & List the Products Ordered Solution

Жыл бұрын

Leetcode SQL 50 | 1484. Group Sold Products By The Date Solution

3:59

Leetcode SQL 50 | 1484. Group Sold Products By The Date Solution

Жыл бұрын

Leetcode SQL 50 | 176. Second Highest Salary Solution

6:34

Leetcode SQL 50 | 176. Second Highest Salary Solution

Жыл бұрын

Leetcode SQL 50 | 1527 - 196 Patients with a Condition & Duplicate Emails Solution

7:10

Leetcode SQL 50 | 1527 - 196 Patients with a Condition & Duplicate Emails Solution

Жыл бұрын

Leetcode SQL 50 | 1667. Fix Names in a Table Solution

3:29

Leetcode SQL 50 | 1667. Fix Names in a Table Solution

Жыл бұрын

Leetcode SQL 50 | 185. Department Top Three Salaries Solution

11:35

Leetcode SQL 50 | 185. Department Top Three Salaries Solution

Жыл бұрын

Leetcode SQL 50 | 585. Investments in 2016 Solution

16:21

Leetcode SQL 50 | 585. Investments in 2016 Solution

Жыл бұрын

Leetcode SQL 50 | 602. Friend Requests II: Who Has the Most Friends Solution

8:45

Leetcode SQL 50 | 602. Friend Requests II: Who Has the Most Friends Solution

Жыл бұрын

Leetcode SQL 50 | 1321. Restaurant Growth Solution

9:11

Leetcode SQL 50 | 1321. Restaurant Growth Solution

Жыл бұрын

Leetcode SQL 50 | 1341. Movie Rating Solution

11:18

Leetcode SQL 50 | 1341. Movie Rating Solution

Жыл бұрын

Leetcode SQL 50 | 626. Exchange Seats Solution

6:15

Leetcode SQL 50 | 626. Exchange Seats Solution

Жыл бұрын

Leetcode SQL 50 | 1978. Employees Whose Manager Left the Company Solution

5:28

Leetcode SQL 50 | 1978. Employees Whose Manager Left the Company Solution

Жыл бұрын

Leetcode SQL 50 | 1907. Count Salary Categories Solution

8:33

Leetcode SQL 50 | 1907. Count Salary Categories Solution

Жыл бұрын

Leetcode SQL 50 | 1204. Last Person to Fit in the Bus Solution

7:03

Leetcode SQL 50 | 1204. Last Person to Fit in the Bus Solution

Жыл бұрын

Leetcode SQL 50 | 1164. Product Price at a Given Date Solution

14:23

Leetcode SQL 50 | 1164. Product Price at a Given Date Solution

Жыл бұрын

Leetcode SQL 50 | 180. Consecutive Numbers Solution

9:01

Leetcode SQL 50 | 180. Consecutive Numbers Solution

Жыл бұрын

Leetcode SQL 50 | 610. Triangle Judgement Solution

4:23

Leetcode SQL 50 | 610. Triangle Judgement Solution

Жыл бұрын

Leetcode SQL 50 | 1789. Primary Department for Each Employee Solution

12:25

Leetcode SQL 50 | 1789. Primary Department for Each Employee Solution

Жыл бұрын

Leetcode SQL 50 | 1731. The Number of Employees Which Report to Each Employee Solution

8:57

Leetcode SQL 50 | 1731. The Number of Employees Which Report to Each Employee Solution

Жыл бұрын

Leetcode SQL 50 | 1045. Customers Who Bought All Products Solution

4:01

Leetcode SQL 50 | 1045. Customers Who Bought All Products Solution

Жыл бұрын

Leetcode SQL 50 | 619. Biggest Single Number Solution

5:25

Leetcode SQL 50 | 619. Biggest Single Number Solution

Жыл бұрын

Пікірлер

@AchintyaChoudhari

@AchintyaChoudhari Ай бұрын

I loved your approach of solving every question .....

@godsgiftuloamaka

@godsgiftuloamaka 3 ай бұрын

Clear, and nice video.

@ankitmishra-in4sy

@ankitmishra-in4sy 5 ай бұрын

really good 😇

@kartikkatara5999

@kartikkatara5999 6 ай бұрын

nice explanation, way better then other video, thanks

@sherzod_axadov

@sherzod_axadov 7 ай бұрын

good explanation🔥, thanks

@vijethkashyap151

@vijethkashyap151 7 ай бұрын

Thanks for the video! This channel is underrated!!

@NikhilAsawadekar

@NikhilAsawadekar 8 ай бұрын

couldn't get 'and e.subject_name = s2.subject_name' part.

@DanielDuong-kx1wj

@DanielDuong-kx1wj 10 ай бұрын

Great explaination!, cảm ơn bạn

@TrangNg25 10 ай бұрын

Thank you! Let me know if you have any questions or concerns about my explanation!

@sumanthkonduru2160

@sumanthkonduru2160 Жыл бұрын

Do 1st query work in oracle ?

@TrangNg25 Жыл бұрын

Hi, yes, it should run successfully in Oracle. You might want to modify the code a little bit. For example, HAVING COUNT(submission_id) > 1 instead of HAVING CNT > 1. Give it a try, and let me know if it works for you.

@sumanthkonduru2160

@sumanthkonduru2160 11 ай бұрын

@@TrangNg25 ya it's working thanks for your reply trangNg if possible post tutorials on oracle sql and pl/sql