Answer for SQL Stored Procedures OUT, User-Defined Functions - Question regarding Query

https://365datascience.com/dwqa-answer/answer-for-sql-stored-procedures-out-user-defined-functions-question-regarding-query/ -

Hi Maros!

Thanks for reaching out.

Since the data in our database has been organised perfectly well, your intuition should be perfectly correct. 

We’ve written the query this way because it is supposed to work even if the salaries table contains employee numbers that have not been present in the employees table. 

Therefore, please feel free to share your query with the Community since in our case, your query is expected to deliver identical results.

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