Welcome to the SQL Advent Calendar Challenge!🎄 Each day features a new SQL challenge designed to improve participant's querying skills. Credits to Dawn Choo on LinkedIn who provided these questions.
- Day 1: Customers Renting for Multiple Activities -> Solution
- Day 2: Gifts Weighing More Than 1 kg -> Solution
- Day 3: Ranking Calorie-Packed Candies -> Solution
- Day 4: Average Snowfall by Region -> Solution
- Day 5: Beaches with Hot Temperatures on Christmas -> Solution
- Day 6: Tracking Polar Bears’ Migration -> Solution
- Day 7: Highest Revenue Vendors -> Solution
- Day 8: Gifts for Good Recipients -> Solution
- Day 9: Top Calorie-Dense Dishes by Event -> Solution
- Day 10: Tracking New Year’s Resolutions -> Solution
- Day 11: Family Birthdays in December -> Solution
- Day 12: Top 3 Snow Globes with Most Figurines -> Solution
- Day 13: Total Weight of Gifts per Recipient -> Solution
- Day 14: Ski Resorts with Snowfall > 50 Inches -> Solution
- Day 15: Top 3 Family Members with Most Children -> Solution
- Day 16: Total Revenue per Candy Category -> Solution
- Day 17: Advanced and Expert Grinch Pranks -> Solution
- Day 18: Top 2 Activities by Average Rating -> Solution
- Day 19: Maximum Food Consumption by Polar Bears -> Solution
- Day 20: Vendors Selling Items Below $10 -> Solution
- Day 21: Santa's Sleigh Optimization -> Solution
- Day 22: Missing Gift Assignments -> Solution
- Day 23: Weight Change for Each Day -> Solution
- Day 24: Cumulative Gifts Delivered -> Solution