Latest Videos
[LeetCode SQL 50] 1070. Product Sales Analysis III Toán tử IN và SUB QUERY
GoNion
29 views·2 months ago
[LeetCode SQL 50] 1141. User Activity for the Past 30 Days I So sánh ngày
GoNion
26 views·2 months ago
[LeetCode SQL 50] 1934. Confirmation Rate Vận dụng CASE và AVG() để tính tỉ lệ
GoNion
32 views·4 months ago
[LeetCode SQL 50] 1661. Average Time of Process per Machine ROUND() và AVG()
GoNion
40 views·4 months ago
[LeetCode SQL 50] 595. Big Countries Dịch đề, phân tích & demo trên LeetCode
GoNion
41 views·5 months ago





![[LeetCode SQL 50] 1070. Product Sales Analysis III Toán tử IN và SUB QUERY](https://i.ytimg.com/vi/Eso9gOI07TA/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBbukp2IrtrENhVanMHT3oliR5BSQ)
![[LeetCode SQL 50] 1141. User Activity for the Past 30 Days I So sánh ngày](https://i.ytimg.com/vi/jXLQ6xAm_hc/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLA6Zze0108qTsArT-1n7oMAZd607g)
![[LeetCode SQL 50] 2356. Number of Unique Subjects Taught by Each Teacher COUNT() và DISTINCT](https://i.ytimg.com/vi/ritKcWpt9ck/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDyV6NueukNNO6SzJhIakNk02XLEg)
![[LeetCode SQL 50] 550. Game Play Analysis IV DATE_SUB() và DISTINCT](https://i.ytimg.com/vi/mCc_xHJX_Tg/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLA31I7BEZ0JeQ4-JFJKyhVmrl7beQ)
![[LeetCode SQL 50] 1174. Immediate Food Delivery II Lược bỏ CASE - WHEN](https://i.ytimg.com/vi/acX1x3HHSvs/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLALOT42ZUbMni4YFRRaookxLHz5Ug)
![[LeetCode SQL 50] 1193. Monthly Transactions I Kết hợp DATE_FORMAT(), COUNT(), SUM() và CASE](https://i.ytimg.com/vi/Lli4BKAFa2w/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAKkBfDyf9nhf7qL_o0OVrIfOMr4A)
![[LeetCode SQL 50] 1211. Queries Quality and Percentage AVG() và CASE](https://i.ytimg.com/vi/1_Yt742jBVM/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAinExcb5BSaGD43qDrrnyagUJT8w)
![[LeetCode SQL 50] 1633. Percentage of Users Attended a Contest Sử dụng COUNT() và SUBQUERY](https://i.ytimg.com/vi/fJsCXWyaBJY/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLC_TmgeH852jMIxIDknmd92yJuysQ)
![[LeetCode SQL 50] 1075. Project Employees I INNER JOIN, ROUND() và AVG()](https://i.ytimg.com/vi/P4HREwdPVZA/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLC8H7gsh9ngJL8wCVLHmiyH3T_MWg)
![[LeetCode SQL 50] 1251. Average Selling Price COALESCE() và BETWEEN](https://i.ytimg.com/vi/QSKkdcp0984/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCMUgzNusnZqJC83VhbAy1VMz9heQ)
![[LeetCode SQL 50] 620. Not Boring Movies Vận dụng phép chia lấy dư](https://i.ytimg.com/vi/VPAQCqfAn64/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAFmTq3rPVTOelPOH72wdqrbovFfQ)
![[LeetCode SQL 50] 1934. Confirmation Rate Vận dụng CASE và AVG() để tính tỉ lệ](https://i.ytimg.com/vi/TCOtrZ3r2Ic/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDsRcuQutTpbpk4Z8By1_L4u3XCfA)
![[LeetCode SQL 50] 570. Managers with at Least 5 Direct Reports GROUP BY và HAVING](https://i.ytimg.com/vi/HEnKE9qK1DQ/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAkeeI4wbV5YDD2qk5IHaQqAIYJ7A)
![[LeetCode SQL 50] 1280. Students and Examinations Kết hợp COUNT() với CROSS JOIN và LEFT JOIN](https://i.ytimg.com/vi/ihcr5D7m_0c/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCbm0P5XCCyjPnwsmGzqmAS2_EE4g)
![[LeetCode SQL 50] 577. Employee Bonus LEFT JOIN](https://i.ytimg.com/vi/-I_JexCUXuw/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDuD8WDXbCOq9fyneqx_aNZGZGTwQ)
![[LeetCode SQL 50] 1661. Average Time of Process per Machine ROUND() và AVG()](https://i.ytimg.com/vi/JaI9VToWYjE/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLA14RCu_UwEG89OMXDbfZ7IARfqrQ)
![[LeetCode SQL 50] 197. Rising Temperature CROSS JOIN và DATEDIFF()](https://i.ytimg.com/vi/OwkD0QZ48kk/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBOTuaQWIa_E-EsR0fTSvLvheQLaA)
![[LeetCode SQL 50] 1581. Customer Who Visited but Did Not Make Any Transactions GROUP BY và COUNT()](https://i.ytimg.com/vi/yIx8fTVMGkA/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDJ1CQaqtswM9SHZ6AGDCOrWZui4A)
![[LeetCode SQL 50] 1068. Product Sales Analysis I LEFT JOIN](https://i.ytimg.com/vi/Zra9HBD3Iis/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAVxFkLDhgPJ5JWP8bQ8SX_52jJgA)
![[LeetCode SQL 50] 1378. Replace Employee ID With The Unique Identifier LEFT JOIN](https://i.ytimg.com/vi/UR1KHGYP2oo/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAOl8Pg27Klwcnz38tUQayXXO7NZQ)

![[LeetCode SQL 50] 1683. Invalid Tweets Hàm LENGTH() và CHAR_LENGTH() trong MySQL](https://i.ytimg.com/vi/mKKcvGSX1oA/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCuO0_38PklOCAjNFkySzdji9HBnw)
![[LeetCode SQL 50] 1148. Article Views I Dịch đề, phân tích & demo trên LeetCode](https://i.ytimg.com/vi/Uc1Mb0-4lvM/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAvypMG6gby-mpvU-HDpR3JUC5qOw)
![[LeetCode SQL 50] 595. Big Countries Dịch đề, phân tích & demo trên LeetCode](https://i.ytimg.com/vi/IGdHKLQvlOM/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDFSJBqkX59AHkl_fYCf6OX6BvxRA)
![[LeetCode SQL 50] 584. Find Customer Referee Dịch đề, phân tích & demo trên LeetCode](https://i.ytimg.com/vi/C__ZliZNmWw/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLASxfj8-IjeYgqGPBvxbeteJORL5A)