SQL - I was given 4 tables Sales, Product, Promotion and something else (Never had to use it). 1. Which product had the highest sales with promotions and sales ( basically a where clause on 2 flags) 2. What % of sales happened on the first and last day of promotion. I don't remember the rest.. I'd say your ability to translate regular english statements into SQL is tested very well
SQL question that involved window functions
basic sql and python problem
Null +1 = ? Union and Union Alll which one is faster
We have two types of reviewers: careful reviewer (80% of reviewers) and lazy reviewers (20% of reviewers). Careful reviewers rate a post positive 60% of time and negative 40% of time). Lazy reviewers however rate a post positive 100% of time. A) what is the probability that a random ad is reviewed positively? B) If an ad gets a negative review, what is the probability that it's reviewed by a lazy reviewer? C) If 3 ads are reviewed positively in a row, what is the probability that they are reviewed by a lazy reviewer? D) Some as above with n positively reviewed ads in a row. What happens when n goes to infinity? E) If we have very few labeled data, how can we build a model to distinguish between careful and lazy reviewers?
Take-home exercise on a typical analysis case and was asked to provide solution and thought process in a week.
Know SQL Joins.
Are the two processes similar or different explain with statistical evidence
There were some specific stats questions that I wished I had answered better.
what is ensemble Learning Algorithms kinds ?
Viewing 801 - 810 interview questions