Answer for Stored procedures - Example - Part II

https://365datascience.com/dwqa-answer/answer-for-stored-procedures-example-part-ii/ -

Hi Vivian!

Thanks for reaching out.

1. This is a great observation. Yes, it does work. In our example, we wanted to focus on creating a MySQL Procedure, hence we have simplified that part of the answer.


2. Providing the specific query you are referring to may help in our explanation. However, in general, the idea is that you need to provide aliases when using a subquery, since this is a selection of information that exists only temporarily. You can say that it exists only “in the life of the query”, so to speak. Therefore, it needs to be given an alias for a reference.   

Hope this helps.
Best,
Martin

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy