thomzi12

8 ms·

31.
by thomzi12 6y ago
Hey! MAU = Monthly Active Users. Sorry about that, I think this could be described as data analyst/analytics jargon. Good feedback to spell these out, thanks!
32.
by thomzi12 6y ago
Yep, Ollien made a similar point. Currently some of the questions have expected output but not all.
33.
by thomzi12 6y ago
Yes -- making this a proper webpage with an embedded SQL editor like selectstarsql.com does would be a good next step
34.
by thomzi12 6y ago
Good catch -- I can add that in as an alternate solution. Thanks!
35.
by thomzi12 6y ago
Yeah, it's because (1) I started this doc over a year ago when I was still at Salesforce (which owns/employees use Quip) and (2) AFAIK Google Docs still doesn't have native code block support :/
36.
by thomzi12 6y ago
Some of them have sample output but yes, it would be helpful to extend this to all examples. Good feedback!
37.
by thomzi12 6y ago
Great resource! I have personally found the top Leetcode SQL questions to be hit-or-miss without curation (too easy, too hard, doesn't cover topics like window functions / self-joins like I would encounter in interviews, etc.) but
38.
Medium-hard SQL interview questions(quip.com)
1230 points by thomzi12 6y ago|287 comments
39.
by thomzi12 6y ago
Hey, HN! Since I couldn't find a good resource online for the self-join and window function SQL questions I've encountered over the years in interviews, I made my own study guide which I'm now sharing publicly as a Quip doc.
40.
by thomzi12 7y ago
How did Clearview scrape so much of Facebook? Is this fundamentally hard for Facebook, Instagram, Linkedin, etc. to stop if someone determined wants to suck in photos for a tool like this?
41.
by thomzi12 7y ago
Awesome! Some quick comments: * What about non-human use cases, like shearing pets between seasons? If you can solve getting pets to stay still could be a possible initial use case. Seems easier to get traction! * As pitched, this seems mo
42.
by thomzi12 8y ago
That's really interesting to see more Latinx developers (7.3%) than East Asian developers (5.3%) as a proportion of all professional developers. It's an awesome surprise, but is there a measurement reason for this? Unfortunately,
43.
Leaving NYC for Nashville(wesmckinney.com)
5 points by thomzi12 8y ago|0 comments
44.
by thomzi12 8y ago
Contrarian opinion: repetitive writing is actually important in helping us remember what the article or book is talking about. Humans learn via repetition. If we took out the fluff, the article/book would be <50% as effective as it
45.
by thomzi12 8y ago
*FAANG
46.
This Is No Time to Go to Pot(wsj.com)
4 points by thomzi12 8y ago|0 comments
47.
by thomzi12 8y ago
Activists at an institution are very different people from the admissions personnel at an institution
48.
by thomzi12 8y ago
Why didn’t he leave to the private sector?
49.
by thomzi12 8y ago
What was the point of the rebranding?
50.
by thomzi12 8y ago
I actually quit Prime after moving to San Francisco — it felt hard to justify when grocery stores and other shopping is blocks away. People forget about walking, haha. I just don’t buy enough stuff to warrant the subscription.
51.
by thomzi12 9y ago
Did you not read the article? Millions of users took a personality test that had nothing to do with politics, and that data was sold to the Trump campaign for targeting. When did Obama’s campaign ever do that?
52.
by thomzi12 9y ago
I don't get the outrage over this -- haven't Uber and Lyft and Google been doing this for years?
53.
by thomzi12 9y ago
Could someone compare this to Dask? Would you use the two in different situations?
54.
by thomzi12 9y ago
Um, people have been “rabidly” consuming fiction since the Greeks created theater?
55.
by thomzi12 9y ago
To echo someone else's post, saying you work at [a boring tech company] working on [boring ideas] is what is truly taboo in Silicon Valley.
56.
by thomzi12 9y ago
Interesting article, kind of wish it started off with some context and simple reporting on the situation though -- I'm not familiar with the story.
57.
by thomzi12 9y ago
Without earnings per hour metric, it's hard to make much of this post.
58.
Salesforce Trailhead Releases Employee Tracker(zdnet.com)
2 points by thomzi12 9y ago|0 comments
59.
by thomzi12 10y ago
Yes, it helped. But how much jerkery are we willing to tolerate? And, for how long? Uber isn't an early stage start-up anymore.
60.
by thomzi12 10y ago
What exactly makes you think Uber would hire your friend? This isn't Wall Street in the 80s where hustling is what matters. You have to have technical skills and experience working in tech. Your friend might want a job at Uber, doubtfu

More ›