Blind Tax: 110K + 0.01% Paper Equity ($400M Series B Startup - Already Vested hence looking for higher base) Here’s the question for anyone applying. I’m pretty sure I butchered it. /* This is just a small sample from tables with many more rows Given Two SQL tables: User_age +-----------------------------+ | userid | age | country | |----------|------|-----------| | 111 | 47 | ‘India’ | | 222 | 45 | ‘India’ | | 333 | 23 | ‘Italy’ | | 444 | 47 | ‘Italy’ | +-----------------------------+ user_names +-----------------------+ | userid | name | |----------|------------| | 111 | ‘mark’ | | 444 | ‘mark’ | | 222 | ‘mark’ | | 333 | ‘bob’ | | 555 | ‘amy’ | +-----------------------+ Question: Find all pairs of userids with the same names, output userid_1, userid_2, name. We do not want duplicates. So for example, if we have 111,222, mark. Then NO 222,111, mark Expected output: /* 111, 222, mark 111, 444, mark 444, 222, mark */ Rarely use SQL in my current role mainly do integrations and write typescript all day, this is a non coding role. How would you do it? #tech #facebook #faang #meta #interview
Do they have some kind of sql engine for you to experiment ? Or is this like a whiteboard interview
Just did this interview. Can confirm they asked this question. Meta sa seems like a decent gig even though pay is less than aws/nvidia/gcp sa
Ask Blinders
Yesterday
616
Thinking of choosing a name Aria for my baby boy.
Ask Blinders
12h
484
Why no one cares about the lives lost in Gaza, Israel and busy in their own lives?
India
6h
626
Rahul Gandhi is poison but the people who believe in him are a lot worse
Tech Industry
Yesterday
5159
BREAKING: Internal sources confirm another round of layoffs just hit emails at Tesla. For real.
Tech Industry
8h
448
Does blind still love Google most?
What did you write?
SELECT User_age.userid FROM User_age OUTER JOIN ON User_age.userid = user_names.userid UNION SELECT user_names.userid, user_names.name FROM user_names SELECT User_age.userid, user_names.userid, user_names.name FROM User_age JOIN ON User_age.userid = user_names.userid WHERE User_age.userid != user_names.userid
Yikes. You need a distinct clause in there.