I am having a problem with the last part of question 1 at the 8:10 timestamp of the video. When I tried to aggregate the home and away records I get the following error: Error Code 1248: Every derived table must have its own alias (Using MySQL 8.0 Workbench). Any suggestions as to how to solve this error?
Hi, Thank you for the content. I cant make the 1st question work on MY SQL workbench. Did it my way at first and came close but couldnt quite get to the end result. Then i copied your code but the last bit doesnt execute. Any ideas?
![ค้าง (STILL) - GEMINI [ OFFICIAL MV ]](http://i.ytimg.com/vi/Ftxx3hk5vkU/mqdefault.jpg)
I just landed my first job as a jr data engineer. Will be starting this November 4. Couldn't have done it without you sir. Thank you!
Congratulations, this is awesome news! Thanks for sharing. I'm glad i could help.
Amazing video!!
Thank you!!
Thanks for the Video.
You’re welcome
I am having a problem with the last part of question 1 at the 8:10 timestamp of the video. When I tried to aggregate the home and away records I get the following error:
Error Code 1248: Every derived table must have its own alias (Using MySQL 8.0 Workbench).
Any suggestions as to how to solve this error?
Cool to see SQL applied to something that many people enjoy watching/following
Thanks! I thought it was a good concept to share too
I'll be watching
Good to hear!
Hi, Thank you for the content. I cant make the 1st question work on MY SQL workbench. Did it my way at first and came close but couldnt quite get to the end result. Then i copied your code but the last bit doesnt execute. Any ideas?
What error are you getting? Or how is the result different?