Tag: Reporting

Learn How To Write SQL Queries With Examples: #6

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 #1270, Level: Medium) Table: Employees +—————+———+ | Column Name | […]

Learn How To Write SQL Queries With Examples: #5

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

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

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

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 #177, Level: Medium) Write a SQL query to get […]

SQL Joins: A Guide That Makes It Stupid – Simple

Share This Post: Businesses across the globe have evolved over the past decade. With companies striving to Digitally Transform their value chains and become more Lean and Agile, Analysts and Program/Project/Product Managers of today need to become data-driven problem solvers. To solve problems using data, one needs to access, analyze and report on the business […]