Intermediate-Advanced SQL and Practical Data Analysis: 101 Problem Solutions
Learn intermediate to advanced SQL and solve 101 real-world data analysis problems together to build solid SQL data analysis skills.
Updated Intermediate-Advanced SQL and Practical Data Analysis 101 Problem Solving Materials
Hello. This is Dave Lee from Janjaemi Coding.
I have updated the material as there is a minor data update.
When using ORDER BY in SQL's window function , the basic frame is RANGE as the default. Therefore, as explained in the lecture, RANGE is the default. However, there was a part in the data where I made a mistake and wrote ROWS as the default. Thanks to the person who reported it, I was able to confirm the relevant part. Thank you.
I have also updated the relevant materials. If there are any issues since it is still early, please let me know at dream@fun-coding.org and I will check. However, I am currently on a business trip abroad, so I will check by the end of this week.
thank you
Remnant fun coding Dave Lee Dream