Tag: Window Functions

Learn How To Write SQL Queries With Examples: #5

Post author By RUCHITA SALUJA
Post date July 6, 2021
Categories In Business, Learning SQL, SQL Q&A Series

Question Source: LeetCode Solution Language: MySQL This Q&A series will cover data questions from LeetCode and present my solutions to them. Please feel free to comment with your suggestions if you feel that these problems may be solved in a more optimized manner. Question (LeetCode Question #1412, Level: Hard) Table: Student +———————+———+ | Column Name | […]

Learn How To Write SQL Queries With Examples: #4

Post author By RUCHITA SALUJA
Post date June 27, 2021
Categories In Business, Learning SQL, SQL Q&A Series

Question Source: LeetCode Solution Language: MySQL This Q&A series will cover data questions from LeetCode and present my solutions to them. Please feel free to comment with your suggestions if you feel that these problems may be solved in a more optimized manner. Question (LeetCode Question #262, Level: Hard) Table: Trips +————-+———-+ | Column Name | […]

Learn How To Write SQL Queries With Examples: #3

Post author By RUCHITA SALUJA
Post date June 25, 2021
Categories In Business, Learning SQL, SQL Q&A Series

Question Source: LeetCode Solution Language: MySQL This Q&A series will cover data questions from LeetCode and present my solutions to them. Please feel free to comment with your suggestions if you feel that these problems may be solved in a more optimized manner. Question (LeetCode Question #185, Level: Hard) Table: Employee +————–+———+ | Column Name | […]

Learn How To Write SQL Queries With Examples: #2

Post author By RUCHITA SALUJA
Post date June 24, 2021
Categories In Business, Learning SQL, SQL Q&A Series