@AirahandMama
I have applied for entry level data analyst role. Prepared for the interview with simplilearn. I got exactly same questions. I was sooo happy and confident. Just finished my interview a minute ago. Waiting for the result.
@blakebagwell8871
For question 42, I believe you should sum based off of the LineTotal instead of the UnitPrice. Reason being that you ask for total units sold greater than 1.5 million and each SalesOrderID could have multiple units of the same product in it. The unit price only picks up one of those units within each SalesOrderID while the LineTotal picks up the price of all units within that order. Line #2 of the sales order total table is an example, that order has 3 units of the same product ID and the unit price line only picks up one of those units. So the sql statement would be the same, just change SUM(sod.UnitPrice) to SUM(sod.LineTotal) in both the select and having statements.
@haiyingwang5987
Super useful content and tightly structured. Better audio quality would've been even more awesome!
@itssimplymg4682
Have a data analyst interview tomorrow and I have never really gotten into data science things, so watching this last minute. Wish me luck loo
@winniew5560
I really like this type of video gives you useful information with examples. Theories need practice. 1 by 1 combined theory+example really helps! Appreciate!
@Luis-kd2te
Thank you for this content. I got some reviewing to do :)
@TheBaBaLand
Love how hes about to go asleep at some moments, because of how basic all of these are to him. Surely he's a pro. But this is so Awsome! Thanks a lot for putting this together!!! <3
@manjunathgb2672
have a data analyst interview on monday ! Lets see how it goes
@davidkaramagi
Thanks for the video, it's really insightful ❤
@YuliaTkachenko-p4z
Thank you very much! it is really usful content for beginer analytics
@mahimabhalla8622
Than you archangel michael for this awesome video for my interview Than you universe ❤️❤️😘😘🥰🥰
@hulkg10outdoors85
Good stuff, you should put more out like this.
@shilonghuang749
Thank you. super useful.
@nitinrawat7581
Thanks for the video 👍
@dheerajkumark2268
Kindly make videos on latest unique data Science projects for freshers in 2020
@tobibonike
kindly explain the difference between data analysis and big data analysis, for me. Thank you.
@prettymimiBakaka
Hi, In question 33, why the query has the having clause avg(mkt_price)> 50 whereas the question asks for the average market price to be greater than 100? Am I missing something?
@danielwie8472
Thank you for a nice and informative video! Also agree with Wang that you should buy a new microphone ;)
@omkars764
Good stuff, thank you
@SimplilearnOfficial