Solving Danny Ma's 8 Week SQL Challenges with SQL in Snowflake ❄️
Twitter 💬 | LinkedIn 👔 | GitHub | YouTube 📺
Learning SQL helped shape and develop my career as a data analyst. Danny Ma has put together a series of SQL challenges that will improve your SQL problem-solving skills. This repo shares my solutions to the tasks, please note there are multiple ways of answering these questions.
For these challenges I have loaded the data into Snowflake to get more familiar with that platform, some of my solutions may not work across different SQL platforms due to differences in function naming and availability.
Challenge | SQL Script | Walkthrough | Blog Post | Skills Tested |
---|---|---|---|---|
Case Study 1 - Danny's Diner | SQL ❄️ | YouTube 📺 | 3 Tips for Week 1 📖 | Ranking, Common Table Expressions (CTEs), Case Statements, Dates and Scalar functions |
Case Study 2a - Pizza Runner | SQL ❄️ | YouTube 📺 | 3 Tips for Week 2a 📖 | Searching Text, Case Statements, NULLs, Datetime and Scalar functions |
Case Study 2b - Pizza Runner | SQL ❄️ | YouTube 📺 | 3 Tips for Week 2b 📖 | Datetime formatting, NULLs, Type conversions, Text manipulation |
Case Study 2c - Pizza Runner | SQL ❄️ | YouTube 📺 | Commma Seperated Strings, Aggregration, Unions, NULLs, CTEs, Type Conversions | |
Case Study 3 a&b - Foodie Fi | SQL ❄️ | YouTube 📺 | CTEs, Row Number, Date Functions | |
Case Study 4a - Data Bank | SQL ❄️ | YouTube 📺 | Calculating stats, Median and Percentile | |
Case Study 4b - Data Bank | SQL ❄️ | YouTube 📺 | End of month calculations, Running sums and conditional aggregations |