This challenge is a part of Serious SQL course
-
Skills learnt:
☑ Perform Data Cleansing and Exploratory Data Analysis with SQL
☑ Use SQL Reverse Engineering for problem-solving
☑ Combine CTEs, JOIN, Aggregate Functions, and Window Functions to solve real-life business problems
☑ Perform String Transformations, Datetime Manipulation and make use of Regular Expressions
-
What to improve:
❎ Practice using Recursive CTE to solve advanced problems
❎ Comprehend and use Window Frame with window functions