Meta Data Science interview questions

Table 1: users_disabled: user_id (int), disabled_reason (string), date(string) Table 2: actors: user_id1(int), user_id2(int), probability_of_same_user(double) Count the number of users for each disable_reason in the past 7 days? question 2 (not sql): Which features make us realise that a user is a returning one?

1. prescreen (ask your background, location preference, relative skills) 2. video total time 45min (coding question+ case question) 3. virtual onsite (coding question+case question+case question+quantitative/statistics question) each round is 45min