Q1) Find the number of unique days each employee worked Emp Id Task Id Start date End date 1 1 Monday Wednesday 1 2 Monday Tuesday 1 3 Friday Friday 2 1 Monday Friday 2 1 Tuesday Wednesday Hint: Calendar day table or date dimension table Calendar_day Calendar_day_of_week Calendar_year Calendar_month 1900/01/01 Wednesday (3) 1990 1 Q2) How many customers placed orders every month? Table 1: Customer Date customer_id order_id units country 2019/07/01 A 112 5 US 2019/07/02 A 211 4 US 2019/08/02 B 511 4 EU 2019/09/01 C 322 1 JP 2019/09/01 C 322 2 JP 2019/08/05 A 378 6 US 2019/09/10 A 456 7 US
Business Interview Questions
153,424 business interview questions shared by candidates
Tell me about a time you overcame a challenge and what you learned. They a lot of follow up questions for each situation.
Given the company forms a partnership with Hulu. The subscription fee is $2 per customer per month and ad revenue is $3 per customer per month, for additional customers. Hulu has 50 million subscribers and the adoption rate is 20%. How will this affect the company? How long can the company last without making loss?
Questions regarding academics and previous work experience
Why not higher studies
Many questions on scenarios related to position requirements.
What do you know about this job.
I'm thinking of a number between 1 and 100. You have 3 guesses. Go. Then I was asked to do it again but this time I would receive £100 for getting it on the first try, 50 for the second and 25 for the third, obviously nothing if I didn't guess.
Can you work more than 10 hours every day ?
Q2 There are 2 trains A and B moving towards each other. A is at a speed of 100kmph B is at a speed of 70kmph. There is a crow sitting on train A and when A and B are 200km apart from each other the crow starts flying towards B at a speed of 30kmph. How much time Will it take the crow to reach B.
Viewing 101 - 110 interview questions