Learn SQL with this exciting 8-week challenge from Danny Ma. Here is the link to the website: 8weeksqlchallenge.com/case-st...
In this video, we are covering questions 9, 10 and two bonus questions 11 and 12 that utilize the CASE statements, aggregate functions, window functions and over clause. Try it out after watching the full video. Table creation and insert statements are provided here:
embed.db-fiddle.com/912b55b7-...
🎤🎤 Mic I use for recording videos: amzn.to/3HcF6cb
📚📚 Book Recommendation:
Learn Storytelling with Data: amzn.to/3vv8Xdg
Timecodes:
0:00 - Intro
0:24 - Question No. 9
8:04 - Question No. 10
17:30 - Bonus Question 1
22:11 - Bonus Question 2
Checkout the Videos page to explore other videos that you may find interesting!
💜💜 Spread some love by Subscribing to the channel. Hit the 👍Like button if you enjoyed this video! 💜💜
I would really appreciate your feedback. Please let me know your thoughts via comments.
🌱 "Never cease to Learn & Grow!" 🌱
#sql #8weekchallenge #dannyma #learnsql #sqlserver #windowfunctions #aggregate #case
2 июл 2024