Meta Data Scientist Infrastructure Strategy interview questions

-- Technical screen, 60 minutes -- 1) 3 SQL questions involving aggregation and/or joins; given a table with unique user ids and non-unique names, return all pairwise combinations of user_ids associated with the same name (only return one of (id1, id2) and (id2, id1)) 2) Coding question, given a string input return whether it is a valid number (cant convert directly to float or use regex) 3) open-ended ML/logistic regression questions, hypothesis testing