Answer for How do I solve this SQL question?

https://365datascience.com/dwqa-answer/answer-for-how-do-i-solve-this-sql-question/ -

Hi Steven!

Thanks for reaching out.

Normally, our policy reflects your intuition in a way – we wouldn’t want to answer questions that are not related to a database we know in detail, because we will be limited in our chances of providing a well explained answer. 

In this specific case, the guidance to provide is not much different from the idea you already have – it seems that you do have to take into consideration the mean and median values. And you are right in your intuition about Table B. 

The way in which your knowledge of SQL can help you understand this task better is to think of how many records there are in Table B (only 100), and what kind or JOIN has been used (a LEFT JOIN). 

Which is the table on the left – Table A, which contains 1 million rows, right?

With these facts in mind, you may try to guess whether to expect an output of thousands or units. And then, your statistical knowledge should help you in specifying the first two digits of the number you are looking for.

That said, let me repeat that we avoid answering questions that have not been provided by us and hope you can agree with us about this.

I still hope this helps somehow!

Best,
Martin

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