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 | […]
Tag: Data Analysts
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 […]
Learn How To Write SQL Queries With Examples: #1
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 #176, Level: Easy) 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 […]
My First Visualization Project on Tableau Public
Share This Post: I’d been thinking about trying out Tableau Public for quite some time. This weekend, I finally got to it. The first step was to select the dataset I wanted to use and determine the questions to be answered by analyzing this data. So, I decided to pick a topic that’s of interest […]