This repository serves as the solution for the 8 case studies from the #8WeekSQLChallenge.
It showcases my ability to tackle various SQL challenges and demonstrates my proficiency in SQL query writing and problem-solving skills.
A special thanks to Data with Danny for creating these insightful and engaging SQL case studies! 👋🏻
Please find the solution links for the case studies below. Simply click on the links to access each solution.
- Case Study #1: Danny's Diner
- Case Study #2: Pizza Runner
- Case Study #3: Foodie-Fi
- Case Study #4: Data Bank
- Case Study #5: Data Mart
- Case Study #6: Clique Bait
- Case Study #7: Balanced Tree
- Case Study #8: Fresh Segments
These are scripts that answer questions from hackerank. Links to questions and my answers are below!
| Question | Difficulty Level | Subdomains | Answer |
|---|---|---|---|
| Weather Observation Station 20 | Medium | Aggregation | Solution |
| Top Competitors | Medium | Basic Join | Solution |
| Challenges | Medium | Basic Join | Solution |
| Ollivander's Inventory | Medium | Basic Join | Solution |
| The Report | Medium | Basic Join | Solution |
| Contest Leaderboard | Medium | Basic Join | Solution |
| Placements | Medium | Advanced Join | Solution |
| New Companies | Medium | Advanced Select | Solution |
| Binary Tree Nodes | Medium | Advanced Select | Solution |
| Question | Difficulty Level | Answer |
|---|---|---|
| Histogram of Tweets | Easy | Solution |
| Data Science Skills | Easy | Solution |
| Page With No Likes | Easy | Solution |
| Unfinished Parts | Easy | Solution |
| Laptop vs. Mobile Viewership | Easy | Solution |
| Average Post Hiatus (Part 1) | Easy | Solution |
| Teams Power Users | Easy | Solution |
| Duplicate Job Listings | Easy | Solution |
| Cities With Completed Trades | Easy | Solution |
| Average Review Ratings | Easy | Solution |
| App Click-through Rate (CTR) | Easy | Solution |
| Second Day Confirmation | Easy | Solution |
| Cards Issued Difference | Easy | Solution |
| Compressed Mean | Easy | Solution |
| Pharmacy Analytics (Part 1) | Easy | Solution |
| Pharmacy Analytics (Part 2) | Easy | Solution |
| User's Third Transaction | Medium | Solution |
| Sending vs. Opening Snaps | Medium | Solution |
| Tweets' Rolling Averages | Medium | Solution |
| Highest-Grossing Items | Medium | Solution |
| Signup Activation Rate | Medium | Solution |
| Signup Activation Rate | Medium | Solution |
This repository is licensed under MIT License - see License for more details
© 2023 An Tran